Compare values on different worksheets

M

Matt

I want to use a function that will take a SerialNumber
listed on worksheet one and check to see if the same
SerialNumber appears on worksheet two.

There are many SerialNumbers listed in a column of each
worksheet. If it appears on both worksheets, I need it to
flag the find on Worksheet one.
 
E

Eric

I would do a VLookup in the first sheet next to the column
with your data that looks up A1 in Sheet 1 in your
database on sheet two. If it finds it it will put the
number again in column B, if not it will put #Na. Copy
paste special as values for column B, then sort by column
be and any number without an #Na beside it is also on
sheet 2.

Hope this helps,

Eric
 

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

VBA Coding Help for Beginner 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Syncing between source worksheet and dependent worksheets 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Embed the same Excel multiple times 0
Scrubbing two excel worksheets, returning unique values from one sheet 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Ttest across multiple worksheets 0

Top