Hi..
how do i search a cell to see if it contains any one of several words?
For a single word I'm using:
=IF(ISNUMBER(SEARCH("LB",a1)),"Buy","")
But if within cell "a1" I want to check if it contains either "LV" or "GUC" or "DG"? (where a1 is a string of text e.g., "AMLVDM") what do I use?
Thanks very much.
Bookmarks