On Jan 13, 11:40*am, Pete_UK wrote:
You could do something like this in C2:

=IF(B2="","",IF(COUNTIF(A$2:A$25,B2&"*")0,"X","") )

then copy this down to cover the names that you have in column B.

Note that because this uses wildcards, you will get matches with
entries like "J" in column B.

Hope this helps.

Pete

On Jan 13, 4:05*pm, wrote:



This seems that it should be simple, but i can't figure it out. any
help is appreciated.

Column A contains last name, first

Column B contains last name

I want Column C to indicate (maybe by inserting an X) any last names
in Col B that match a last name in col A- Hide quoted text -

- Show quoted text -

Thanks Pete. Using this, I only appear to be matching up with first
names. i.e. last name column = James, is being coded as a match
because there are some first names listed as James. this is fine,
however it's not locating any of the last names.