Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
snax500
 
Posts: n/a
Default Find last match in vllokup

In Excel2000, I have the following data:


Tom 100
Pete 200
Joe 300
Tom 500


I want to have a Vlookup that finds "Tom' and gives me 500 NOT 100. I
know vlookups usually finds the first instance of a match but I want
the last ( there could be 5 or 4 or 3 records of Tom). Can this be
done?


Thanks

  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:


Take a look at the answer to your previous, nearly identical question...

Use CountIf() to determine the number of the instance to return.

In article .com,
"snax500" wrote:

In Excel2000, I have the following data:


Tom 100
Pete 200
Joe 300
Tom 500


I want to have a Vlookup that finds "Tom' and gives me 500 NOT 100. I
know vlookups usually finds the first instance of a match but I want
the last ( there could be 5 or 4 or 3 records of Tom). Can this be
done?


Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up data in colum a and find match in colum b Chris(new user) Excel Discussion (Misc queries) 1 March 22nd 05 02:41 PM
Check data on colum A and find match on colum b Chris(new user) Excel Discussion (Misc queries) 3 March 20th 05 05:45 PM
Look up data in colum a and find match in colum b Chris(new user) Excel Discussion (Misc queries) 1 March 19th 05 10:27 PM
find LAST match in column Pantryman Excel Worksheet Functions 7 February 24th 05 12:18 PM
Find a match that;s not exact Phyllis Excel Worksheet Functions 0 November 8th 04 09:12 PM


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"