Lookup across columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Back
Top