Index Match Formula

[daznav]

Guys im stuck on the fact of how to pull the correct information through for a named person.as from the example if i place say steve in the named box i would like all of steves scores to appear in the designated boxes.and so on
any ideas

Thank you

[shg]

Please take a few minutes to read teh forum rules, and then amend your thread title accordingly.

Thanks.

[daznav]

My apologies im just unsure of what formula would carry out the task in hand

[martindwilson]

something like
=INDEX(Sheet2!$A$2:$E$31,ROWS($A$1:A2),MATCH(Sheet1!$B$8,Sheet2!$A$2:$E$2,0))

[daznav]

what cell would this need to go in im unsure sorry

[martindwilson]

well im not sure what you want where but that if put in b11 and dragged down will retrieve thos figures from sheet 2 for whover is in the drop down

[daznav]

Thanks alot that solves 1 part i will have a play and see if i can crack the rest of what i need to do first cheers again

[daznav]

sorry guys reposting because i have changed the way i need to look at things but problem is how do i index in rows now it was in a column before i just dont get index match sorry ,i have left a new example if you could help many thanks. i need a formula to go in H11 on sheet 1 to show the scores from sheet 3 E6 and along???

[martindwilson]

in that case just go back to a vlookup instead

[daznav]

That is exactly what i need but what does the part where you have put ROWS A1:A2 IN i dont get it all.

Many thanks anyway

[martindwilson]

rows($a$1:a1) returns 1
when dragged down that increments becoming
rows($a$1:a2) returning 2 and so on 3,4,5........
saves having to change each one manually
so
=VLOOKUP($B$8,Sheet3!$D$6:$AF$20,ROWS($A$1:A2),FALSE)
is the same as
=VLOOKUP($B$8,Sheet3!$D$6:$AF$20,2,FALSE)

[daznav]

Thanks for the explanation i know youve explained well but i dont get it at all thanks anyway i willmark as solved