Hello,

I have a column of text values and on another sheet I have five columns of
text values (there are five columns because there are over 300000 records). I
need a formula that will tell me if the text value in the first list appears
anywhere in the five column list.
--
Thanks in advance,
MarkN