INDEX MATCH

[j4ymf]

Hello All

Im struggling with a INDEX MATCH where the results are returning the correct values but not in the correct cells.
Im looking for the best formula to mirror the top picture into another sheet

What im seeing is my results are going down where im expecting for them to go across

In the top picture we are creating a weekley labour planner and the second picture an overview page.
any ideas why its not working?

=IFNA(INDEX('Site Overview'!$E$7:$ZZ$24,MATCH($R$6,'Site Overview'!$E$6:$ZZ$6,0),MATCH(O8,'Site Overview'!$B$7:$B$24,0)),"")

 

[Fluff]

You look to have the two match functions the wrong way round. You need to match the row & then the column.

 

[j4ymf]

Great thank you Fluff

 

[Fluff]

You're welcome & thanks for the feedback.