# Look up new numbers from old list in new list

Closed
Rabbit84 - Jul 9, 2009 at 02:42 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 11, 2009 at 10:38 PM
Hello,
i am trying to look up new number in one list in a new list to see if there was new data added w/ the new list. I would like for the new numbers to appear in F2:F9. So look up ID numbers in E2:E9 in old list B2:b9 but but the new number results in F2:f9 if there is a new number.

example

A B C D E F
1 nAME Job ID Name New Job ID New ID numbers
2 Jon 1234 Jon 1234
3 ben 2589 Ben 8863 8863
4 sam 7896 Sam 7896
5 tom 7412 Tom 7413 7413
6 Kid 4563 Kid 4563
7 Kim 2364 Kim 2364
8 Joe 0154 Joe 0155 0155
9 Jay 9863 Jay 9866 9866

I hope you understand what I am talking about.
Related:

## 4 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 11, 2009 at 03:03 AM
Hi Rabbit84

try =IF(Countif(B2:b9,"=" & e2)>0,"",e2)
OMG, thank you soooo much this is what I was lookikng for. I tried the vlookup formula but that was not the best one, I mean it worked but instead of giving me the result, it have a #N/A and I had to look beside the #N/A to get the answer.

How did you find that formula? I am soo happy.
Rabbit84 Posts 1 Registration date Friday July 10, 2009 Status Member Last seen July 11, 2009
Jul 11, 2009 at 09:56 AM
Sorry to bother you again, I have another question.

From the first question that i asked you, is there a way that the result can be highlighted? I guess what I am trying to say is, Jon gets a new list everyday. Everytime the a new list comes out, Jon needs to know what numbers are new, and what numbers are not on his list any more. So, I guess what I am trying to say is there anyway that his add on numbers from the new list be highlighted in Column F, and the numbers that are not on his list anymore be highlighted in column B instead of displaying it in Column C or G. I hope you get what I am talking about. Also, I'm going back to school for Office System Technial. I love thinking and anything that has to do with math, I'm all for it. What is a good career field for me. I work for one of the biggest banks in the world, and I work with a bunch of dumb smart people. I need a career change. (hope thats not to personal to ask)

A B C D E F G
Agent Old List Saves Agent New List Adds
Jon 12345 Jon 12345
Jon 12988 12988 Jon 83987 83987
Jon 12987 Jon 18749 18749
Jon 17859 17859 Jon 39283
Jon 20192 Jon 76545
Jon 39283 39283 Jon 99212
Jon 46371 46371 Jon 78685 78685
Jon 56557 56557 Jon 98274
Jon 75849 75849 Jon 20192 20192
Jon 76545 76545 Jon 11564 11564
Jon 76564 76564 Jon 8881 8881
Jon 98274 98274 Jon 11297 11297
Jon 98767 98767 Jon 12987 12987
Jon 99212 99212 Jon
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 11, 2009 at 10:38 PM
Hi Rabbit84

Try this for v =if (iserror(vlookup(,,,)),value,"")
for your second question , I dont know any no straight way with excel but can be done using excel VBA