Michael has attended:
Excel Advanced course
VLOOKUP
Hi All,
Vlookup and Hlookup return the first entry that matches the criteria how do we return the second/third/etc.?
Thank you.
Sincerely,
Michael
RE: VLOOKUP
I assume you are using something like the following formula:
=VLOOKUP(D2,Range1,1,FALSE)
Where it says 1 (after the Range1) then you need to change this to 2/3 etc as this is the column number so for example:
=VLOOKUP(D3,Range1,2,FALSE)
When using a range all columns must exist in your range