|
What Formula?
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 |
What Formula?
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 |
| All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com