Comparing columns from 2 different worksheets.

A

Alant

I have 2 worksheets. I need to compare the cells in column1/worksheet1 to
the cells in column1/worksheet2. If a cell in column1/worksheet1 is nowhere
in column1/worksheet2, then I want to display the missing cells in
column1/worksheet3 along with the corresponding column2 cells from
worksheet1. Note: worksheet 2 has many more rows than worksheet1.
Thanks
 
M

Miguel Zapico

One way of doing it is using this function on sheet 3, column A:
=IF(ISNA(MATCH(Sheet1!A1,Sheet2!$A$1:$A$1000,0)),Sheet1!A1,"")
And on column B:
=IF(A1="","",VLOOKUP(A1,Sheet1!$A$1:$B$500,2,FALSE))
It will create a lot of blank rows, you can then sort the column and delete
the blanks.

Hope this helps,
Miguel.
 

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

Top