Thanks for responding, what I'm trying to do is take a list of about 8,000
7-digit numberical serial numbers (column A) and a list of about 2,000 serial
numbers that have been purchased for extended warranty (column), so some of
the numbers in column B will also be in column A. Instead of going through
every serial number in column A and manually searching column B to see if it
was a serial that also had extended warranty purchased on it, I was hoping
for a formula or some means, that would take all the serial numbers in column
A and see if there is a duplicate of that same number in column B, indicating
it has an extended warranty purchased on it.

Does that make sense?

"Biff" wrote:

Hi!

There are many ways to do this but what exactly do you mean by have one
column search another?

How do you designate that an extended warranty has been purchased?

If the warranty was not purchased is the cell left blank?

What result do want if the warranty was or was not purchased?

Are the serial numbers unique?

Biff

"accessgrits" wrote in message
...
I have two columns of data, one for serial numbers I have sent out, and one
where extended warranties that were purchased. Instead of always using
the
find feature, is there a way to automate it so that the first column can
search the second to see if an extended warranty was purchased?

Thanks in advance for your help!