| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with INDEX, MATCH
I have a sheet with data on it and another with a list of names. On the Names
Sheet i need to return the data from the Data sheet. Names Sheet A B Sue 100 Sue 300 Sam 500 Bill 100 Data Sheet A B C 100 Any data Sue 100 Any Data Bill 500 Any Data Sam 300 Any Data Sue i have the formula so far, but it only finds the first occurance of "Sue" =INDEX(Data Sheet!A1:C4,MATCH(A1,Data Sheet!C1:C4,0),1) I also would like it to determine the range based on how many rows are on the data sheet as it changes in length |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with INDEX, MATCH
=INDEX('Data sheet'!A:A,MATCH(A1,'Data sheet'!C:C))
Regards, Stefi €˛Lemmesee€¯ ezt Ć*rta: I have a sheet with data on it and another with a list of names. On the Names Sheet i need to return the data from the Data sheet. Names Sheet A B Sue 100 Sue 300 Sam 500 Bill 100 Data Sheet A B C 100 Any data Sue 100 Any Data Bill 500 Any Data Sam 300 Any Data Sue i have the formula so far, but it only finds the first occurance of "Sue" =INDEX(Data Sheet!A1:C4,MATCH(A1,Data Sheet!C1:C4,0),1) I also would like it to determine the range based on how many rows are on the data sheet as it changes in length |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Hybrid Mode
