How to make VLOOKUP search from the bottom to the top of the list

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 »

This entry was posted in Functions. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

One Comment

  1. Azmi
    Posted September 19, 2014 at 6:38 pm | Permalink

    great formula…. but how can i explain,,,how the array works?
    =LOOKUP(2,1/(A:A=G2),B:B)

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*