Lookup across columns

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.
 
P

Pete_UK

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
 
L

Lori

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

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

looking up multiple values in an arrray 5
Excel Vlookup of multiple values 6
Lookup based on two variables and return a third 3
which formula? Match? IF? 4
using the =page! feature to transpose a row to column 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
"IF" function query 5
With F1 value, look at A, if match or partial match return B 5

Top