Vlookup and matching

Ryan M
Ryan M ✭✭
edited 12/09/19 in Formulas and Functions

Good morning, 

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!