Need help with Index and Match formula on the "Dancer Recap" tab PLEASE???

[tstjuste]

I've attached a spreadsheet where I need to populate formula's on the "Dancers Recap" tab and I've inserted comments for your reference.

Any and ALL help would be greatly appreciated as I was supposed to have this finalized on Friday

Thank you in advance.

[daffodil11]

B4:

=IFERROR(INDEX(DD!$E$3:$FO$28,MATCH(B$1,DD!$B$2:$B$5,0),MATCH($A4,DD!$E$1:$FO$1,0)),"")

C4:

=IFERROR(INDEX(DD!$F$3:$FP$28,MATCH(B$1,DD!$B$2:$B$5,0),MATCH($A4,DD!$E$1:$FO$1,0)),"")

and copy down.

Once you have copied both down, you can copy B4:C44 and paste across all columns

[tstjuste]

Thank you so much it works perfectly!!!!

[daffodil11]

No problem. Glad I could help out.

If that answers the question, please be sure to mark the Thread as Solved in the thread options at the top. Then the mods won't have to later on.

[tstjuste]

It looks like I ran into a little snag on the formula....when I have dancers with the same first name (I have 7 instances of this), it's not bringing in the correct dancer's order. Can you please help me?

[daffodil11]

No problem, we just add a layer to the formula and then convert it to an array.

[tstjuste]

Thank you SO much daffodil11! I'm trying to learn all this but often it stumps me. I really appreciate you taking time to help me!