Lookup using 2 cells as the "X" and "Y" coordinates....

G

Guest

I am trying to make a formula that will look at two cells (K2 and L2) which
can have the following typed in them:
K2 can be "A, B, C, D, or E"
L2 can be "I, II, III, or IV"
I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of Sheet2)
Based of of what is typed in the cells I want to look it up in the array.
Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count cell if value present in every other cell + criteria 2
geting a if/and number off of two list cells 2
=I2>=LARGE($I$2:$I$5,2) ... to be modified 14
Worksheet functions using one out of every five cells 0
Scrabble Value calculation for Welsh words 0
Four criteria MATCH INDEX lookup of date between matching two text 9
Concatenation using IF AND - Possible? 3
A sort of lookup or match 1

Top