|
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 |
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 |
| All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com