small tweak to formula needed to show false

[xtreme07]

hi,

i have this formula
=LOOKUP(2^15,SEARCH(Table3,A2),Table3)

atm it's showing #N/A for false. instead, i would need it to display 0

 

[Ganjin]

a tad long, but should achieve what you want:
=IF(ISERROR(LOOKUP(2^15,SEARCH(Table3,A2),Table3)),0,LOOKUP(2^15,SEARCH(Table3,A2),Table3))

 

[xtreme07]

a tad long, but should achieve what you want:
=IF(ISERROR(LOOKUP(2^15,SEARCH(Table3,A2),Table3)),0,LOOKUP(2^15,SEARCH(Table3,A2),Table3))

Edit: it works .. ty very much

 

[Aladin Akyurek]

...
it's showing #N/A for false. instead, i would need it to display 0

If on 2007 or later...

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(Table3,A2),Table3),0)

If on a previous version...

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",LOOKUP(9.99999999999999E+307,SEARCH(Table3,A2),Table3)))

which gives you a formula blank... You can replace 0 with 0&"" if so desired, giving you a text-number.

Note. In order to get the last numeric value from a range reference or an array reference, you see zillions of "personalized" variations on the big number 9.99999999999999E+307 which you can find under Excel's limits. The formulas above stick to Excel's own constant.