| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can vlookup be used to retrieve multiple matches
Say, I have a worksheet that has Column A for work orders, Column B
for parts A work order may contain many parts on different rows: Column A Column B WO123 PN5 WO123 PN6 WO123 PN7 WO121 PN9 WO122 PN4 WO122 PN7 etc I want to automatically "look up" a work order and "import" the parts used into another worksheet - to create a "flat/horizontal" statement like "WO122 used PN4 and PN7". How do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to return the sum of multiple matches | Excel Discussion (Misc queries) | |||
| How do I retrieve & view multiple matches from another workbook? | Excel Worksheet Functions | |||
| How do I get multiple matches when using the Vlookup function? | Excel Worksheet Functions | |||
| Multiple matches on VLOOKUP | Excel Worksheet Functions | |||
| Using VLOOKUP with multiple first column matches | Excel Worksheet Functions | |||
Threaded Mode
