| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If statement with lookup array... any advice?
What are you trying to achieve with the formula? what value do you want to return, or from which column? DanH;314936 Wrote: 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. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=88037 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement with lookup array... any advice? | Excel Discussion (Misc queries) | |||
| If Statement / Array | Excel Worksheet Functions | |||
| IF statement with 2 array formulae | Excel Worksheet Functions | |||
| IF statement in Array Formula's | Excel Discussion (Misc queries) | |||
| Array If statement doesn't work | Excel Worksheet Functions | |||
Hybrid Mode
