silverlucky5
New Member
- Joined
- Sep 8, 2009
- Messages
- 35
Hi All,
Hoping someone can help me out
I have the following lookup table.
<tbody>
</tbody>
I want to look up the values shown in "Lookup Value" column below and return results (from Lookup Table) as shown below. (FYI: There doesn't necessarily have to be a blank in "Lookup Value" column for the other 2 "Atlanta" results and the multiple results don't have to be in any particular order.)
<tbody>
</tbody>
I know VLOOKUP will only return the first value of Atlanta as shown below. I have tried all kinds of formulas with MATCH and SMALL and INDEX but I'm not having too much luck.
<tbody>
</tbody>
Does anyone know how I would create a formula (preferred) or a macro to do this?
Thank you!
Hoping someone can help me out
I have the following lookup table.
A | B | C | |
1 | Branch | City | Material |
2 | Branch1 | Atlanta | Paper |
3 | Branch1 | Atlanta | Cloth |
4 | Branch1 | Atlanta | Wood |
5 | Branch2 | Boston | Cardboard |
6 | Branch3 | Dallas | Plastic |
<tbody>
</tbody>
I want to look up the values shown in "Lookup Value" column below and return results (from Lookup Table) as shown below. (FYI: There doesn't necessarily have to be a blank in "Lookup Value" column for the other 2 "Atlanta" results and the multiple results don't have to be in any particular order.)
A | B | C | |
1 | Lookup Value | Result1 | Result2 |
2 | Branch2 | Boston | Cardboard |
3 | Branch3 | Dallas | Plastic |
4 | Branch1 | Atlanta | Paper |
5 | Atlanta | Cloth | |
6 | Atlanta | Wood |
<tbody>
</tbody>
I know VLOOKUP will only return the first value of Atlanta as shown below. I have tried all kinds of formulas with MATCH and SMALL and INDEX but I'm not having too much luck.
A | B | C | |
1 | Lookup Value | Result1 | Result2 |
2 | Branch2 | Boston | Cardboard |
3 | Branch3 | Dallas | Plastic |
4 | Branch1 | Atlanta | Paper |
<tbody>
</tbody>
Does anyone know how I would create a formula (preferred) or a macro to do this?
Thank you!