Help with INDEX, MATCH

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
 
S

Stefi

=INDEX('Data sheet'!A:A,MATCH(A1,'Data sheet'!C:C))
Regards,
Stefi

„Lemmesee†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index and Match 3
Adding data from multiple cell and linking to a new worksheet 3
count formula 2
How to match to Worksheets 3
Match / Index multiple criteria return multiple results 2
Is it possible to pick up formatting from range using index match? 4
Index Match Problem 4
Indirect with index and match 2

Top