Comparing two lists. . . simpler than I'm making it

[mrexcel2008]

Hello friends,

I have two lists of names.

The lists are identical except one is more updated (some data has been removed). Specifically the more recently-updated list has 135 fewer names on it.

In Column A I have the updated (shorter) list of names, in Column B the older list that is longer.

I want to remove the 135 names from the newer list. I am OK with doing this by hand.

What I'm looking for is a function that will spit out a list of the names I need to remove from the old list.

I have heard VLOOKUP is my function, but to date, despite all my reading on the internet, I have not been able to see how I could craft a vlookup that would give me the results I want.

Any advice is appreciated.

 

[Jonmo1]

Welcome to the board...So if the name in column B DOES NOT appear in Column A, it should be removed from Column B ?

Why not just paste the New list over the top of the Old list??

 

[mrexcel2008]

Because the list of names I am trying to update is actually extracted from a Google doc.

I could just paste the updated list from Excel into my Google spreadsheet, but that would lead to data corruption, because the names are associated with a number of different other fields that hold important data.

And the updated list also includes some new names that don't appear in the old list at all. In other words, it has both additions and deletions, which would throw off the order in which data is recorded in other columns, and dissociate it from particular names.

Hope this makes sense.