Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Multiple matches on VLOOKUP

Question about VLOOKUP...


In Sheet1, I have my source data.

| A | B |
-------------------------
1 | 1 | =vlookup(a1,map,2, false)
--------------------------
2 | 2 | =vlookup(a2,map,2, false)


In Sheet2, I have my "map" defined for cells A1:B4

| A | B |
---------------------------------
1 | 1 | data1
---------------------------------
2 | 2 | data2
---------------------------------
3 | 2 | data2b
---------------------------------
4 | 2 | data2c
---------------------------------

The first record works great.

The second one poses a problem since I have multiple occurences of
record #2. It only picks up the first one.

Any idea how I can have all occurences returned?

Thanks.


Dennis Hancy
Eaton Corporation
Cleveland, OH

  #2   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default

Hello Dennis,

maybe my vlookupall() function can help you:
http://www.sulprobil.com/html/vlookupall.html

HTH,
Bernd
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Here's a formula that can retrieve more than one match

http://tinyurl.com/e39qs

however I would personally use a filter


Regards,

Peo Sjoblom

" wrote:

Question about VLOOKUP...


In Sheet1, I have my source data.

| A | B |
-------------------------
1 | 1 | =vlookup(a1,map,2, false)
--------------------------
2 | 2 | =vlookup(a2,map,2, false)


In Sheet2, I have my "map" defined for cells A1:B4

| A | B |
---------------------------------
1 | 1 | data1
---------------------------------
2 | 2 | data2
---------------------------------
3 | 2 | data2b
---------------------------------
4 | 2 | data2c
---------------------------------

The first record works great.

The second one poses a problem since I have multiple occurences of
record #2. It only picks up the first one.

Any idea how I can have all occurences returned?

Thanks.


Dennis Hancy
Eaton Corporation
Cleveland, OH


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
how do I use vlookup for multiple occurrences of the same value bj Excel Worksheet Functions 0 April 27th 05 10:43 PM
how to deal with multiple matches on vlookup? Ash Excel Discussion (Misc queries) 3 March 10th 05 04:38 PM
Using VLOOKUP with multiple first column matches John Simons Excel Worksheet Functions 2 February 20th 05 02:27 AM
Can VLOOKUP return multiple answers based on several identical lo. jddtct Excel Worksheet Functions 3 January 11th 05 08:03 AM
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 02:56 AM


All times are GMT +1. The time now is 02:43 PM.

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

About Us

"It's about Microsoft Excel"