Index and Match with multiple criteria

[Lynn D]

Hello, I need help figuring out how to index and match the values in the table at the bottom of the spreadsheet with column a and column b with row 2 and return the value at the intersection into the green shaded cells. I've tried everythign I know. Thanks,

[mcmahobt]

Will this formula work? Enter into cell G29 as an array with CTRL+SHIFT+ENTER and drag down.

G29:  =IFERROR(INDEX($F$3:$AB$26,MATCH($A29&$B29,$A$3:$A$25&$B$3:$B$25,0),MATCH($C29,$F$2:$AB$2,0)),"")

Hope this helps!

[Lynn D]

This worked perfectly. You are awsome. Thanks

[AlKey]

Try this

=SUMPRODUCT(($A$3:$A$26=$A29)*($B$3:$B$26=$B29)*($F$2:$AB$2=$C29)*($F$3:$AB$26))