Compare values on different worksheets

  • Thread starter Thread starter Matt
  • Start date Start date
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.
 
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
 
Back
Top