R
RayG
I need to be able to enter a value into two different cells and return a
value from a table to match a certian value from that table.
two cell values sheet 1 A1= 1" A2= 75# if you go to 1" and across to 30# you
get 23.99 this is the value I would like to have returned. The table is on
sheet 2 of the same workbook. It's not really a table its just data in cells.
Trap Size 25# 30# 75#
1/2" 3.31 3.83 8.4
3/4" 9.2 10.64 23.35
1" 20.74 23.99 52.65
1 1/4" 26.59 30.76 67.51
1 1/2" 36.79 42.55 93.39
2" 57.48 66.49 145.93
2 1/2" 82.72 95.7 210.02
3" 112.56 130.22 285.79
Hope this is not clear as mud to ya...
value from a table to match a certian value from that table.
two cell values sheet 1 A1= 1" A2= 75# if you go to 1" and across to 30# you
get 23.99 this is the value I would like to have returned. The table is on
sheet 2 of the same workbook. It's not really a table its just data in cells.
Trap Size 25# 30# 75#
1/2" 3.31 3.83 8.4
3/4" 9.2 10.64 23.35
1" 20.74 23.99 52.65
1 1/4" 26.59 30.76 67.51
1 1/2" 36.79 42.55 93.39
2" 57.48 66.49 145.93
2 1/2" 82.72 95.7 210.02
3" 112.56 130.22 285.79
Hope this is not clear as mud to ya...