Subscribe!

The title of this post is slightly misleading. We will not be using vlookup to return the corresponding result of the last condition, but rather we will be mimicking vlookup to pull the last item.

Consider the following data:

George Smith
Tom Thompson
George Kenny
Dan Jackson
Sally Richards
George Daniels

A vlookup of the name George will return Smith, What if you want to lookup the last George listed? The solution is to use the lookup function:

=LOOKUP(2,1/(A1:A6=A7),B1:B6)

Where:
A1:A6 = the lookup range
B1:B6 = the data to return
A7 = The condition (The item to lookup)

For more advanced lookups like returning the 2nd occurrence of George, you can try the VlookupPlus Excel Add in.

Joseph Harris
Excel Help

Related posts:

  1. Vlookup Multiple Criteria in Excel The standard vlookup function allows for one condition to be...
  2. Multiple Condition Vlookup Function Add-in – Excel The question we are asked most often by ExcelYogi readers...
  3. Vlookup – My Favorite Function Vlookup...

This entry was posted on Wednesday, March 18th, 2009 at 11:20 am and is filed under Excel Hints, Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.