R
rsetzer
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?
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?