Find function

[Pazzaj]

Hi All,

I am trying to use a FIND function where I can search for multiple varibles instead of one. I need to search a huge list of email addresses and filter out those that contain the normal ISP tags - gmail, hotmail, aol etc. but I don't know how to search for more that one string at a time.

Does anybody know how search for multiple variables in one cell?

Thanks,

Ed

[tigeravatar]

Ed,

Give this a try:
=IF(OR(ISNUMBER(SEARCH({"@gmail.com","@hotmail.com","@aol.com"},A1))),"Found","Not Found")