First off this may be a repeat post I not quite sure. See the thing is when
I post questions for some reason they don't always appear or if they do I
can't find them. Even when I search for them.

So here it is again
=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 trying to use this formula find information problem is there is to many
"". I have confused excell and get 50 back as my answer 9 out of 10 times is
there a way to fix this or a simpler to calculate this.

Thanks again

See replies in other newsgroup (worksheet.functions)

Advice is use VLOOKUP.

"Excluxe" wrote:

First off this may be a repeat post I not quite sure. See the thing is when
I post questions for some reason they don't always appear or if they do I
can't find them. Even when I search for them.

So here it is again
=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 trying to use this formula find information problem is there is to many
"". I have confused excell and get 50 back as my answer 9 out of 10 times is
there a way to fix this or a simpler to calculate this.

Thanks again