looking up cell value based off of row and column information

G

Guest

I have a chart with unit codes in the far left column and exchange codes in
the top row. each unit code has a corresponding price based on the exchange
code at the top of the column:
A B C D E
1 C07c C07B A13G A14B
2 ABC1 $1.25 $1.26 $1.27 $1.30
3 ABC2 $1.32 $1.25 $1.30 $1.31
4 XYZ3 $13.50 $15.21 $16.20 $15.49
5 ZXY4 $6.25 $6.20 $6.50 $6.55

What I am looking for is a formula that will allow me to enter a value for
X= (a value in column A) and y= (a value in row 1) that will result in the
cell that matches the intersection of the row and the column the meets the
two criteria, such as when I enter x=ABC2 and y=A14B the result is the
corresponding value $1.31.

Any Ideas?
 
G

Guest

where your x and y values are in G1 and H1

=INDEX(B2:E5,MATCH(G1,A2:A5,0),MATCH(H1,B1:E1,0))
 

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

What formula do I use if I need to look at the column and row? 1
getting column and row names if a cell has a value 4
Looking for row # for highest value AND blank cell in other column 4
Looking up 3 cells based on defined value in a row/column location 4
Is there a (reasonably) simple way to get the intersection of a row and a column? 2
Is there a (reasonably) simple way to get the intersection of a row and a column? (Second request) 3
How to set the value of a cell using its row and column numbers? 2
make a listing of each cell made up of its row and column 1

Top