Choose Value From Table Based on 3 Dropdowns

UL8750 Calculator.xlsx

Hello,

I am trying to return a value from the table in the attached spreadsheet in cell I2, based on the 3 dropdowns in cells C2, C3, C4. Using an example in another post I found I am able to get close, but not quite there.


This is the formula that I am using. It will give me correct values for all of the "Through Air" columns, but when I choose "Over Surface" I get an error.
=INDEX(C10:L14,MATCH(C2,A10:A14,0),MATCH(C3,C7:L7,0),MATCH(C4,C9:L9,0))




Thanks for your help!
-Matt

Try

=INDEX(C10:L14,MATCH(C2,A10:A14,0),MATCH(C3,C7:L7,0)+(C4="Over Surface"))

That worked perfectly. Thanks!

You're welcome.