Column lists and matching

[iloveexcel127]

I have a list with two columns. Column A has all the names, and column B has numbers. I have another list with the same columns but more names and numbers. I would like to find the best way to subtract list 1 numbers from list 2 if they the names match. Those names that are unique in list 2 should be sorted at the bottom of the list. Please help. Thank you.

 

[Tigs81]

Hi
I would use VLookup from a column next to list 1. Then sort but vlookup column then delete rows coming up with a match.


=VLOOKUP(A1,Sheet1!A1:B1000,1,FALSE)
the cells that come up with an error do not have a match.

Thanks
tigs