Excel 2007 : Search for multiple text within a cell

[northerng]

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.

[NBVC]

Try =IF(SUMPRODUCT(--(D1:D4<>""),--ISNUMBER(SEARCH(D1:D4,A1))),"Buy","")

where D1:D4 contain the search criteria

[northerng]

works great..thank you NBVC!

[protonLeah]

Not sure what you are doing but you can play with:

Please Login or Register  to view this content.

[northerng]

thanks protonleah...