Why is the table not populating correctly?

[ILeonFF]

I can fix the #N/A errors later. Im trying to match the row header and column header in the big table with the table on the left. But is not pasting the correct value where it should be at.

 

[sheetspread]

Are you getting d0_22? The others look right.

 

[ILeonFF]

Yes I am

 

[ILeonFF]

Are you getting d0_22? The others look right.

Yeah d1_16 through d1_20 are correct, but d0_21 and d0_22 are not.
Also column "0" is jacked. not sure why it didnt put d0_21 and d0_22 in there.

 

[ILeonFF]

Are you getting d0_22? The others look right.

This is what the end result is supposed to look like

 

[Marcelo Branco]

You should use an array formula. Try

G2 copied across and down
=IFERROR(INDEX($C$1:$C$7,MATCH(1,IF($A$1:$A$7=G$1,IF($B$1:$B$7=$F2,1)),0)),"")
confirmed with Ctrl+Shift+Enter, not just Enter

M.

 

[ILeonFF]

You should use an array formula. Try

G2 copied across and down
=IFERROR(INDEX($C$1:$C$7,MATCH(1,IF($A$1:$A$7=G$1,IF($B$1:$B$7=$F2,1)),0)),"")
confirmed with Ctrl+Shift+Enter, not just Enter

M.

It worked, Thank you!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.