Combining 2 columns usiing wildcards and using concatenate from 2 other columns

[elanda]

Hello,

To simplify what I am trying to do is:

If
column a = fruit
column b = banana/s OR peach/es

then concate columns c and d.

I have done it by testing FRUIT and BANANA/S as below but I don't know how to also look for PEACH/ES as well to both return true.

=IF(AND(ISNUMBER(SEARCH("FRUIT",V3)),ISNUMBER(SEARCH("BANANA*",R3))), "TRUE", "FALSE")

How do I add the final FRUIT + BANANA/S OR PEACH/ES to produce a TRUE result?

much thank for any quidance

 

[AlanY]

try

=IF(AND(ISNUMBER(SEARCH("FRUIT",V3)),or(ISNUMBER(SEARCH("BANANA*",R3)),ISNUMBER(SEARCH("PEACH*",R3))), "TRUE", "FALSE")

 

[elanda]

Thanks for the quick reply Alan.

Your formula works a treat and such a simple solution.

Spent hours on this.

Cheers
Adrian

 

[AlanY]

you're welcome