| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement with lookup array... any advice?
I am trying to automate a spreadsheet. The basic formula is this... Any
suggestions or corrections would be appreciated. =if(Logical_test, lookup_array, lookup_array) actual formula =IF(B3="Back Mount",LOOKUP(B56,{2050,3250,5150,8500,1150,15400, 18250,22500,26000,31000,41000},{128,158,188,228,24 8,278,308,338,368,408,408}),LOOKUP(B56,{3800,5300, 6200,8700,13500,17000,21000,26000,33000},{"X12B39" ,'X15B39","X18B39","X22B39","X24B43","X27B47","X30 B55","X33B55","X27B71"})) I have also tried =IF(B3="Back Mount",LOOKUP(B56,{2050,3250,5150,8500,1150,15400, 18250,22500,26000,31000,41000},{128,158,188,228,24 8,278,308,338,368,408,408}),if(b3="Top Mount",LOOKUP(B56,{3800,5300,6200,8700,13500,17000 ,21000,26000,33000},{"X12B39",'X15B39","X18B39","X 22B39","X24B43","X27B47","X30B55","X33B55","X27B71 "}))"") Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement / Array | Excel Worksheet Functions | |||
| IF statement with 2 array formulae | Excel Worksheet Functions | |||
| Array, Formula, Constant, IF Statement Question???? | Excel Discussion (Misc queries) | |||
| IF statement in Array Formula's | Excel Discussion (Misc queries) | |||
| Array If statement doesn't work | Excel Worksheet Functions | |||
Threaded Mode
