Vlookup and matching

Ryan M

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.  

Paul Newcome

Try something like this...

 

=IF(CONTAINS([Employee Number]@row, {ATL care follow up range 1}), 1)

Ryan M

Thank you so much, I was going in a completely different direction and needed someone to point me in the right direction!! 

Paul Newcome

Happy to help!