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
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