Index Match with multiple criteria (two lookup columns)

Hi,

I am looking to do an index match formula. I have two columns labeled Criteria 1 and Criteria 2. I have a third column labeled Result. I would like to do an index match formula that looks up a value in both the Criteria 1 and Criteria 2 columns and produces the correct result. However, I keep getting an error and don't know what I am doing wrong.

I have attached an excel spreadsheet that shows an example of the above.

Thanks

Hello
Your formula is an array formula and needs to be entered with Ctrl+Shift+Enter. If done correctly, you will see curly brackets {} around the formula. These, however, cannot just be typed in.

DBY

Here's your file with array formula.

Thank you everyone! Both methods work!

Glad we could help. Thanks for the Rep mark.