looking up cell value based off of row and column information
 

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?

looking up cell value based off of row and column information
 

where your x and y values are in G1 and H1

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


"rsetzer" wrote:

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?