| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP-common look up entry with multiple results
Hello...
I need to have the following in a file: Order Serial # 123 ABC 123 DEF 234 GJH 234 JKI When I vlook the order number to get the serial #'s into another file I only get the first instance... eg if I vlook the serial #'s for order 123 I only get ABC returned.....Is ther a way to get multiple results for common lookup value... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up multiple results with VLOOKUP | Excel Worksheet Functions | |||
| Vlookup, multiple results (in different cells)? | Excel Worksheet Functions | |||
| adding multiple vlookup results | Excel Worksheet Functions | |||
| how to return multiple results in vlookup? | Excel Worksheet Functions | |||
| Add multiple vlookup results | Excel Worksheet Functions | |||
Threaded Mode
