I gave you an answer yesterday, it's better that you continue that thread
instead of posting the same question again and if that answer didn't work
post back explain what didn't work


--
Regards,

Peo Sjoblom



"Excluxe" wrote in message
...
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