Vlookup and matching
First time using a Vlookup formula. All I am trying to do is cross reference employee numbers from one sheet to another. If the employee number exists in sheet A and is a match on sheet B, I want it to flag. I think I am over thinking it, Any help would be appreciated.
In the screenshot, the formula will reference (ATL care follow up range 1) to see if the employee number exists in that column, if it does and it matches 111111, I simply want it to flag.
Help Article Resources
Check out the Formula Handbook template!