Offset function to meet two criteria

[tantcu]

Hello,

I need a function that can retrieve a data from the data table that meet two criteria from the two drop down list. Appreciate if you can help. Please see my attached.

ThanksTest.xlsx

[martindwilson]

c23 filled across
=IFERROR(INDEX(D$6:D$12,MATCH($B$20&$C$20,INDEX($B$6:$B$12&$C$6:$C$12,0),0)),"not found")

[tantcu]

Thank you very much!