Lookup function

Hi alisherwani,

welcome to the forum

LOOKUP() requires the data lookup table to be sorted ascending in order to provide the best result, but even then it will return the next approximate value if the match is not found.

My suggestion would be

=VLOOKUP(D25,D7:E23,2,FALSE)

With the FALSE parameter in the VLOOKUP you ensure that only exact matches are returned. (FALSE means: approximate lookup = False)

hth

For the LOOKUP function to work correctly, the data being looked up must be sorted

your data is not sorted, use vlooup instead