If statement with lookup array... any advice?

[DanH]

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,248,278,308,338,368,408,408}),LOOKUP(B56,{3800,5300,6200,8700,13500,17000,21000,26000,33000},{"X12B39",'X15B39","X18B39","X22B39","X24B43","X27B47","X30B55","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,248,278,308,338,368,408,408}),if(b3="Top
Mount",LOOKUP(B56,{3800,5300,6200,8700,13500,17000,21000,26000,33000},{"X12B39",'X15B39","X18B39","X22B39","X24B43","X27B47","X30B55","X33B55","X27B71"}))"")

Thanks.

 

[Simon Lloyd]

What are you trying to achieve with the formula? what value do you want
to return, or from which column?

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,248,278,308,338,368,408,408}),LOOKUP(B56,{3800,5300,6200,8700,13500,17000,21000,26000,33000},{"X12B39",'X15B39","X18B39","X22B39","X24B43","X27B47","X30B55","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,248,278,308,338,368,408,408}),if(b3="Top
Mount",LOOKUP(B56,{3800,5300,6200,8700,13500,17000,21000,26000,33000},{"X12B39",'X15B39","X18B39","X22B39","X24B43","X27B47","X30B55","X33B55","X27B71"}))"")

Thanks.

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)