Hello,



I would appreciate a bit of help...

I have a column of 1000 email addresses say from A1:A1000

I have a series of text cells in a criteria range D1:D3 with the following
data " .com , .net and .org" That criteria range can be extended with
added data.

I would like to have a formula in column B that would show if the cell in
column A contains one of the items in the criteria range (give the results)
, and advise if not in criteria range

A B C
D
1 .com
..com
2 .org
..net
3 "not in list"
..org
4 .com


Thanks in advance

André