Search formula help needed

[londa_vba]

Hello
I have the following formula that works but I need an additional bit that says if B9 does not contain "apple, carrot, or meat" result should = "Other". Whereas right now it displays "False".

=IF(ISNUMBER(SEARCH("Apple",B9)),"Fruit",IF(ISNUMBER(SEARCH("Carrot",B9)),"Vegetable",IF(ISNUMBER(SEARCH("Meat",B9)),"Meat")))

 

[RobP]

Hi,

would this do it for you ?

=IF(ISNUMBER(SEARCH("Apple",B9)),"Fruit",IF(ISNUMBER(SEARCH("Carrot",B9)),"Vegetable",IF(ISNUMBER(SEARCH("Meat",B9)),"Meat","Other")))

 

[londa_vba]

Hi,

would this do it for you ?

=IF(ISNUMBER(SEARCH("Apple",B9)),"Fruit",IF(ISNUMBER(SEARCH("Carrot",B9)),"Vegetable",IF(ISNUMBER(SEARCH("Meat",B9)),"Meat","Other")))

Works perfectly RobP. Thank you

 

[RobP]

great, thanks for the feedback..

Rob