lookup formula

[sachin483]

i am using the below lookup formula but it the value less than 0 it give error

=LOOKUP(F3,{0,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"})

-1	#N/A
44	Excellent
88	Good
90	Average
110	Below Average
155	Poor

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[VBA Geek]

do you want it to return Excellent if below 0 too ? then use:

=LOOKUP(F3,{-9.99999999999E+307,80,90,110,150},{"Excellent","Good","Average","Below Average","Poor"})

 

[sachin483]

Thanks a lot

 

[sachin483]

when i adding the formula for 25 value it is showing "Below average" it should show "Average" as per formula

=LOOKUP(F9,{-9.99999999999E+307,10,20,30,31},{"Poor","Poor","Below Average","Average","Good"})

-99	Poor
<=10	Poor
<=20	below Average
<=30	Average
>31	Good

<colgroup><col><col></colgroup><tbody>
</tbody>