Hello,
Looking do do a vlookup to pull back multiple records for the same lookup value. for example in sheet1 starting A1
<tbody>
</tbody>I want to lookup all values that start with 11237 in sheet2 starting A1
<tbody>
</tbody>
So I want it to pull back
<tbody>
</tbody>
Any help would be much appreciated.
Looking do do a vlookup to pull back multiple records for the same lookup value. for example in sheet1 starting A1
Item | Vendor |
1234 | 11237 |
<tbody>
</tbody>
Vendor ship |
11237-00001 |
11237-00003 |
11237-00002 |
18716-00001 |
18213-00004 |
19173-00001 |
<tbody>
</tbody>
So I want it to pull back
Item | Vendor | Vendor ship |
1234 | 11237 | 11237-00001 |
11237-00003 | ||
11237-00002 | ||
<tbody>
</tbody>
Any help would be much appreciated.