Formula for grid lookup

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?

Assuming the 7 is selected in cell M3 and the E is selected in cell M4, the below formula will work for you.

Formula:

Please Login or Register  to view this content.

See attached.

BSB

Brill stuff. The first one worked a treat. Many thanks.

Help me understand .... why is the formula giving an answer one column and one cell "off" from the indicated coordinates ?

Also, how do you obtain the number listed in 7E, rather than F8 ?