Hi all, I'm wondering what's best for a grid reference-style lookup?

I want to enter a letter in one cell and a number in another cell in order to lookup a grid (table) and produce the value from the corresponding grid reference.

Example:
There's a table (A1:K11), with down-range (A2:A11) with numbers 1 to 10, and across-range (B1:K1) with letters A to J

I want to have two cells with drop-down validation lists (A15 has validation A1:K11, and B15 has validation B1:K1).

So, if I select "7" in the drop down for A15 and "E" in the drop down for A16 then I want A17 to produce the value in the grid reference "7E" (the value in Cell F8)

What's the best formula for Cell A17 to do a cross reference on the grid (table) with inputs from A15 and A16?