Normally, VLOOKUP searches data from top to bottom. But when you have a long list of data and you want to get the latest data at the bottom of the list (instead of the older data at the top), you can’t use VLOOKUP because it always returns the first one it sees from the top, not the latest one.

Here’s a formula that performs a “reverse VLOOKUP”:

`=LOOKUP(2,1/(A:A=G2),B:B)`

Download this sample Excel sheet to see how this “reverse VLOOKUP” formula works »

## One Comment

great formula…. but how can i explain,,,how the array works?

=LOOKUP(2,1/(A:A=G2),B:B)