How to achieve return of one value with multiple criteria

Question

What I'm trying to achieve: Return one value by multiple criteria (from 2 cells). How: Intersection of particular row or column.

Based on picture, Row=Units Sold , Column=Years(2011,2012,2013,Total)

I tried using INDEX+MATCH because it sounded like what I'm looking for. But it doesn't allow multiple criteria, or at least I've tried and failed. I've also tried IF+VLOOKUP, failed again. All my effort would either return error N/A or #Value , etc.

Searched through this website but I can't seem to find what I'm looking for. I'm sure it's pretty simple, but I'm sort of a beginner at Excel. So, apologies if this question overlaps. And, HELP.

Answer 1

Try:

=INDEX(B2:F18,MATCH(H17,B2:B18,0),MATCH(I17,B2:F2,0))