I have 2 sheets with a list of 4-digit numbers. What I need a function
to do is basically "IF A:A=sheet2(all) than replace with 'match' "


I've tried several different variations but can't seem to get it to do
what I want!

I don't want it to touch items that don't match. I need those to stay
what they currently are.