Look things up
Look up by both row and column
=INDEX(B2:C4,MATCH(E2,A2:A4,0),MATCH(F2,B1:C1,0))How it works in Excel
- B2:C4 is the grid of answers.
- The first MATCH finds the row.
- The second MATCH finds the column.
- It works in every version of Excel.
The idea in general
It is like reading a mileage chart: find the row, find the column, and read where they cross.
What I assumed
- The grid is in B2:C4 with labels in column A and row 1, and the two items are in E2 and F2.
Check the result on your own data before relying on it.