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.
 
You must log in or register to reply here.

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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
using the =page! feature to transpose a row to column 0
VLOOK with Index - How to get results across instead of down? 3
"IF" function query 5

Back
Top