=IF(L74="Spiral Preformed steel galv straight
lengths",LOOKUP(G74,{"6x6x4","8x8x4","10x10x4","12 x12x4","14x14x4","16x16x4","18x18x4","20x20x4","24 x24x4"},{7.35,9.05,12.7,14.35,20.5,32.5,41,44.5,50 ,53.5,60}),IF(L74="Steel
PVC coated both sides straight
lengths",LOOKUP(G74,{"6x6x4","8x8x4","10x10x4","12 x12x4","14x14x4","16x16x4","18x18x4","20x20x4","24 x24x4"}),{7.35,9.05,12.7,14.35,20.5,32.5,41,44.5,5 0,53.5}))

I need a formula that will do this. This one confuses the computer when I
choose a number from the drop down list. Lets say 12x12x4 and spiral
preformed steel galv straight lengths my answer seems to be drawn to 50 for 9
out of 10 it will go to that number. How do I solve this I know it is
because I have ten "" text.

Thanks