Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
Hello Dennis,
maybe my vlookupall() function can help you: http://www.sulprobil.com/html/vlookupall.html HTH, Bernd |
#3
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
how to deal with multiple matches on vlookup? | Excel Discussion (Misc queries) | |||
Using VLOOKUP with multiple first column matches | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) |