Compare two Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to compare a list of account numbers with another list of account numbers and determine which account numbers do not show up on the second list. Is there a way to get a list of those accounts that do not show up on the second list. Where do I look for information on this? I am not sure what Terms I should be using.
 
=?Utf-8?B?SG9sbHlBbm4=?= said:
I would like to compare a list of account numbers with another list of
account numbers and determine which account numbers do not show up on
the second list. Is there a way to get a list of those accounts that
do not show up on the second list. ...
Click to expand...

Suppose the first list is in column A and the second in column B.

In C1, put:
=IF(ISERROR(VLOOKUP(A1,B:B,1,FALSE)), "absent", "present" )
and extend it downward for the length of the list.

Modify for your specific needs.
 
THANK YOU. It worked and I did modify the formula so that I could keep the column with the account name. So I should learn more about creating formulas I think. I filtered out the absent accts. Now I have several more worksheets to do this to but now it will be a breeze. Thanks for your help.
 
Back
Top