Help with INDEX, MATCH

  • Thread starter Thread starter Lemmesee
  • Start date Start date
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
 
=INDEX('Data sheet'!A:A,MATCH(A1,'Data sheet'!C:C))
Regards,
Stefi

„Lemmesee†ezt írta:
 
Back
Top