jtovar3

asked on

# I need to See which numbers are missing from two lists in excel

I have a master list of numbers. then i have a list of numbers from barb and from cathy. How can i figure out which numbers are in Barb's list but not Cathy's and which are in Cathy's but not Barbs

I have attached a sample here. I think you would use vlookup?

Thanks!

Comparisons.xls

I have attached a sample here. I think you would use vlookup?

Thanks!

Comparisons.xls

http://office.microsoft.com/en-us/excel-help/use-excel-to-compare-two-lists-of-data-HA001103915.aspx

the following formula works for:

column D

=IF(AND(IFERROR(VLOOKUP(C4,B:B,1,FALSE),"*")<>"*",IFERROR(VLOOKUP(C4,A:A,1,FALSE),"*")<>"*"),"Both","")

column E

=IF(AND(IFERROR(VLOOKUP(C4,B:B,1,FALSE),"*")="*",IFERROR(VLOOKUP(C4,A:A,1,FALSE),"*")<>"*"),"Barb's","")

column F

=IF(AND(IFERROR(VLOOKUP(C4,B:B,1,FALSE),"*")<>"*",IFERROR(VLOOKUP(C4,A:A,1,FALSE),"*")="*"),"Cathy's","")

but i see that you have some values stored as text and some as numbers and this might not work, also not all the values are the same length correct?

column D

=IF(AND(IFERROR(VLOOKUP(C4

column E

=IF(AND(IFERROR(VLOOKUP(C4

column F

=IF(AND(IFERROR(VLOOKUP(C4

but i see that you have some values stored as text and some as numbers and this might not work, also not all the values are the same length correct?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks!