I am having trouble with this and cant figure it out. Sorry if I dont explain this correctly but here it goes.
I have 2 sheets. Sheet1 column A has a list of names that need to be matched against the same set of names listed on sheet 3 column A. When a match is made I would like to be able to have TRUE or FALSE return a different name that I can change.
please let me know if the description is not enough