Comparing Data Between Worksheets

B

Bryan

I have 1 Workbook with 2 seperate sheets. On Sheet 1 Column A is about 13500
par numbers on Sheet 2 Column A is about 12500 Part numbers and Column B is
Item Name.

How can I compare Sheet1 Column A to Sheet 2 Column A?

How can I compare Sheet 1 Column A to Sheet 2 Column A and then see the ones
that are not the same?

Can I have excel match Sheet 1 Column A to Sheet 2 Column A and if they
match brng the information in Column B over to sheet 1 for the matches?

Or am I asking for to much?
 
B

bj

in sheet1 B1
=if(iserror(vlookup(A1,Sheet2!A:B,2,false)),"no
match",vlookup(A1,Sheet2!A:B,2,false))
and copy down to the bottom of your data.
If you want to further highlight the ones with no match
use conditional formating
Select column B
<Format><Conditonal format> formula is =B1="no match" Set fotmat as you want.
Note with conditional formating I sometimes have to go back in and get rid
of extranious quote mates and absolute references when I want relative
references.
 
A

aristotle

Hi,

You need to familiarise yourself with VLOOKUP():

VLOOKUP(Lookup_Value,Range,Col_Index,Match_Type)

Something like =VLOOKUP(A1,Sheet2!A1:B1250,2,0) where common reference is in
column A and data to return is in column B. Use the help feature for
detailed examples.

Regards,
A
 
Top