I have a cost sheet i putting together. I have five sets of information.
Short example is Size 1,2,3,4,5 Price 2,4,6,8,10. I need a formula which
will allow me to draw information from these sets. I have place the size in
a drop down list and using a lookup formula can find the prices by select
whatever size I need but now I need to be able to due this based of another
parameter.
=IF(A2=1,"=LOOKUP(A3,{1,4,5,6,7,8,10,12,14,16,18,2 0,22,24,30,36},{1.08,1.23,1.45,1.62,2,2.46,2.85,4. 24,4.7,5.25,5.8,6.3,9.55,11.45})",IF(A2=2,"B",
IF(A2=3,"C",IF(A2=4,"D","F")))) This formula is what I need but doesn't
work it just lists the secondary formula as text.


Here is how my table looks like

Insulation
Price based type of insulation
Size 1 2 3 4 5
2 .2 .4 .8 1.6 3.2
4 .4 .6 1.2 2.4 4.8
6 .6 .8 1.6 3.2 6.4
8 .8 1 2 4 8

Sizes are the column going down and Types of insulation and there respective
price go across. I am place this info into a sheet that would allow me to
pick a size from a pull down list then an insulation type from a pull down
list and then have the prices called up automatically. Any help would be
appreciated thanks