I am trying to create an IF statement that searches for particular text in a cell. The formula works fine if I use the first IF statement below but when I try to use the second statement I get a VALUE error message.
=IF(ISERROR(SEARCH("BANK",$O5)),"No","BANKCARD") - This one works fine.
=IF(ISERROR(SEARCH("BANK",$O5)),"No","BANKCARD"), =IF(ISERROR(SEARCH("WIRE",$O5)),"No","WIRING") - This one does not.
Last edited by AKEEM; 04-19-2009 at 02:33 PM.
You can combine those like this
=IF(ISNUMBER(SEARCH("BANK",$O5)),"BANKCARD",IF(ISNUMBER(SEARCH("WIRE",$O5)),"WIRING","No"))
or this version can be more easily adapted for use with a longer list of Search/Return values
=LOOKUP("zzz",CHOOSE({1,2},"No",LOOKUP(2^15,SEARCH({"Wire","Bank"},O5),{"WIRING","BANKCARD"})))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks