vlookup (not exact match)

[clarksonneo]

Hi,

will the vlookup function start to lookup value from the bottom or from the top?

I did try many time.
The result tell me that the vlookup function start to lookup from the bottom.

In my picture,
when I lookup "shirt", it return 65
when I lookup "jacket", it return 24

Both suggest that the vlookup function start to lookup from the bottom.

column h is the function in column g
column g is the result

[shrivallabha]

Did you try VLOOKUP with arguments like:

=VLOOKUP(F5,B5:D8,3,0)

Or

=VLOOKUP(F5,B5:D8,3,FALSE)

If you do not specify the last argument then it assumes it to be equal to 1 or TRUE and then gives last value but it doesn't start looking from bottom for sure.