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