Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum column information based on multiple criteria | Excel Worksheet Functions | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS | Excel Worksheet Functions | |||
increment a column based on information in another column | New Users to Excel | |||
Can you conditional format based on information in cell comments? | Excel Worksheet Functions |