Optimizing Excel Model Efficiency with Pre-Calculation

[rmrf2020]

Is your feature request related to a problem? Please describe.
When I use func=excel_model.compile(inputs=inputs, outputs=outputs) to generate a function, I encounter a formula =IF($A5="","",VLOOKUP($I5,PriceTable!$D$2:$H$59711,2,0)/1000*InputSheet!$F$11). My only input is InputSheet!$F$11, and $I5 and $A5 have default values. I'm looking for a way to incorporate the result of VLOOKUP($I5,PriceTable!$D$2:$H$59711,2,0) directly into the formula, like =IF(10="","",1.9/1000*InputSheet!$F$11), to avoid repetitive VLOOKUP execution.

Describe the solution you'd like
An optimization in excel_model.compile(inputs=inputs, outputs=outputs) to pre-calculate or efficiently handle the VLOOKUP($I5,PriceTable!$D$2:$H$59711,2,0) value, focusing on the InputSheet!$F$11 input for smoother processing.

Describe alternatives you've considered
Manual optimization, though impractical for large datasets.

Additional context
This feature would significantly streamline calculations and enhance the utility of the project. Your guidance or suggestions for implementing this would be greatly appreciated. Thank you for your impactful work on this project.