#1   Report Post  
snax500
 
Posts: n/a
Default vlookup second match

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 second. Can this be done?

Thanks

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

Take a look at the "Arbitrary Lookups" topic he

http://www.cpearson.com/excel/lookups.htm

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 second. 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
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 3 December 15th 04 02:38 PM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 0 December 15th 04 12:16 AM
Vlookup, index, match? Phyllis Excel Worksheet Functions 4 December 14th 04 12:23 AM
Find a match that;s not exact Phyllis Excel Worksheet Functions 0 November 8th 04 09:12 PM
Vlookup, Index & Match Phyllis Excel Worksheet Functions 1 November 8th 04 07:11 PM


All times are GMT +1. The time now is 08:10 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"