72 rows

[tlindeman]

I need help with a lookup please. I have a formula in Cell D28 sheet "Model"that results in a number. I need a lookup that looks at that number and gets me the result from the sheet "Production Inputs". For example my result in D28 Sheet "Model" is 72, I need to count 72 rows down on the sheet "production Inputs" Column A and return the result.

Thank You
Tony

 

[auto.pilot]

You can use INDEX:

=INDEX(Production Inputs!$A$1:$A$100,Model!D28)

adjust to your need

 

[tlindeman]

thank you for your help