PDA

View Full Version : vlookup (not exact match)



clarksonneo
03-05-2011, 06:18 AM
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
03-05-2011, 07:05 AM
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.