#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 171
Default vlookup 2nd matching

Vlookup matches 1st matching value in a range,how to match 2nd matching of
same value with vlookup function.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default vlookup 2nd matching

This link

http://office.microsoft.com/en-us/as...260381033.aspx


tells you how to get multiple results.
Use the second result

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"TUNGANA KURMA RAJU" wrote in message
...
| Vlookup matches 1st matching value in a range,how to match 2nd matching of
| same value with vlookup function.


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
Vlookup/matching help needed! for inventory management.... jack Excel Discussion (Misc queries) 4 February 20th 07 10:53 PM
vlookup/matching? much help needed! jack Excel Discussion (Misc queries) 7 February 19th 07 07:22 PM
Help with VLOOKUP or other matching function mpenkala Excel Worksheet Functions 4 January 4th 07 09:52 PM
vlookup with not exactly matching numbers Kelly Excel Discussion (Misc queries) 5 August 4th 06 10:31 PM
Vlookup with non matching data Todd_Aus Excel Worksheet Functions 2 March 13th 06 07:20 AM


All times are GMT +1. The time now is 12:10 AM.

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"