| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup function
Are the three results that you need always grouped in consecutive rows?
If so, you could use MATCH to find the first row number, then INDEX functions to find the appropriate entries. =INDEX(Sheet1!B:B,MATCH("fred",Sheet1!A:A,0)) would get you the first entry (just like vlookup), then INDEX(Sheet1!B:B,MATCH("fred",Sheet1!A:A,0)+1) would get you the second (because the +1 moves down the list one row), etc. "Clinton" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup function
Thanks very much. does what i needed
"bpeltzer" wrote: Are the three results that you need always grouped in consecutive rows? If so, you could use MATCH to find the first row number, then INDEX functions to find the appropriate entries. =INDEX(Sheet1!B:B,MATCH("fred",Sheet1!A:A,0)) would get you the first entry (just like vlookup), then INDEX(Sheet1!B:B,MATCH("fred",Sheet1!A:A,0)+1) would get you the second (because the +1 moves down the list one row), etc. "Clinton" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
