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

Hi Mark,

this could be quite slow unless the data in your second sheet is sorted
and sequential from column A to E. Is it, or can it be?

Pete

MarkN wrote:
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

If data is in Sheet1 and lookup values are in cell A1 downwards, try
filling down this:

=COUNTIF(Sheet1!A:E,A1)0

Thanks Lori,
That worked well although Excel wouldn't let me save the workbook because of
a 'system resources' error! No matter, I got the info I needed.
--
Thanks,
MarkN


"Lori" wrote:

If data is in Sheet1 and lookup values are in cell A1 downwards, try
filling down this:

=COUNTIF(Sheet1!A:E,A1)0