L
Lemmesee
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
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