I suspect this is an easy function but I can't seem to figure out how to do it.
I have a group of names from A4 to A379 on one Tab (Sheet1).
I have another group of names from A4 to A297 on another Tab (Sheet2).
There is significant overlap of names of the two lists.
In Column C of Sheet1 I want to place an 'X' on the same row if that Name also appears on Sheet 2. Otherwise it will remain blank.
An alternative would be some Conditional Formatting but I prefer for an 'X' to be placed next to the name on Sheet1.
Much thanks,
Curt
Bookmarks