Solved

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

Posted on 2010-09-09
317 Views
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
0
Question by:jtovar3
• 2

LVL 8

Expert Comment

ID: 33640555
0

LVL 4

Expert Comment

ID: 33640603
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?
0

LVL 4

Accepted Solution

abitoun earned 500 total points
ID: 33640765
if all Cathy's are text then this will work:
Column D
=IF(AND(IFERROR(MATCH((C7&""),B:B,),"*")<>"*",IFERROR(MATCH(C7,A:A,),"*")<>"*"),"Both","")
Column E
=IF(AND(IFERROR(MATCH((C7&""),B:B,),"*")="*",IFERROR(MATCH(C7,A:A,),"*")<>"*"),"Cathy's","")
Column F
=IF(AND(IFERROR(MATCH((C7&""),B:B,),"*")<>"*",IFERROR(MATCH(C7,A:A,),"*")="*"),"Barb's","")

if not make sure that all three columns are text or all theree are numbers

0

Author Closing Comment

ID: 33640811
Thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Excel 2013 spreadsheet opens without custom margins 13 19
conditional formatting 4 41
locking multiple column ranges 10 23
Excel error  #DIV/0! 7 18
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.