I have two pages, sheet 1 and sheet 2. I have names on sheet 1 and names on sheet two, what I would like to do is if a name on sheet 2 matches that on sheet 1, I would like a text that says "Non FA" next to that name. I can't figure that out. I tried match, If and maybe I need to put them both together. any help is much appreciated.