Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup function
I need to lookup and insert values from sheet 1 into sheet 2. names are not
always alphabetical and can change order. a b 1 name type 2 fred A/L 3 fred PDO 4 fred S/L 5 bob A/L 6 bob PDO 7 bob S/L there is always 3 results for each name to be copied from previous sheet. can only get first type returning in place of the others for each name. Can anyone suggest something. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Lookup Function | Excel Discussion (Misc queries) | |||
using the LOOKUP function | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
lookup function? | Excel Worksheet Functions |