Matching items from two lists

[HHHTheGame]

I haven't run functions in Excel in almost 6 years. How do I match up two columns? I have a list of last names in column one and a list in column two. I just need to know if any of the last names in column one are in column two.

Should be pretty straightforward for all the smart people here...

[VBA Noob]

HHHTheGame,

Welcome to the forum. Please take a couple of minutes to read the forum rules below and then change your title to a more suitable searchable title
VBA Noob

[HHHTheGame]

Got it switched. Sorry bout that.

[VBA Noob]

Thank you

Have a look at this site
http://www.cpearson.com/excel/Duplicates.aspx

VBA Noob

[HHHTheGame]

Thanks for the quick response!

It looks like that link is comparing one list. I'm actually looking at two columns. I've attached the simple sheet. I am looking for something like...

if the value in column A appears in column B, bring back "MATCH", otherwise bring back " ".

Thanks again for your help!!!!

[VBA Noob]

If you read the link you should of seen at the bottom "Extracting Unique Entries In A List" click that and use the formula from there

VBA Noob

[HHHTheGame]

Got it. Found the secondary link...

Extracting Elements Common To Two Lists