| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a macro for returning multiple values through a Vlookup?
Foe eg: Sheet2 contains:
Project# Phase Sp# Details status Manager ... 1234 1-0110 N80 abc Test am 1234 1-0210 N97 def Incom bd 1234 2-0210 N45 lmn Test cf 1234 1-0110 N67 jkl Com er Sheet1 contains: Project# Phase SP# Status Manager 1234 1-0110 The above 2 values are inserted by the user: Now: On running the macro: the sheet 1 should be populated with all the records for phase 1-0110 Desired output: Project# Phase Sp# Status Manager 1234 1-0110 N80 Test am N65 Com er Any help would be greatly appreciated!!! Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Multiple values from A Vlookup | Excel Worksheet Functions | |||
| returning multiple cell values from a vlookup | Excel Worksheet Functions | |||
| Vlookup - returning multiple vertical values | Excel Discussion (Misc queries) | |||
| Using VLOOKUP for returning multiple values and summing them | Excel Worksheet Functions | |||
| vlookup returning multiple values | Excel Worksheet Functions | |||
Threaded Mode
