Formula to Return data in specific cells

**headley4ever** · 01-04-2013, 11:19 AM

Hello Team,

I need help in writing a formula that will return data in specific cells based on a score that is entered in one of these cells. I have attached a file which has two sheets named "Efficiency Measures and Inventory Ratings. Please look at these sheets and you will fully understand what i want the formula to do.

Thanks,
Headley

**benishiryo** · 01-04-2013, 11:33 AM

hi Headley, it'll be good if you can list the minimum score to get those results. i listed mine in M6:M11 for eg. and i dont know how specific your decimal places are, so i used 6 decimal places. my formula in C25 would be:
=LOOKUP($B25,$M$6:$M$11,I$6:I$11)

or if you dont want the list, then:
=LOOKUP($B25,{0.000001;0.96;0.98;0.981;0.99;0.990001},I$6:I$11)

those numbers you see in red are the minimum scores i mentioned.