mcintoshmc
Active Member
- Joined
- Aug 10, 2007
- Messages
- 277
Worksheet A contains a list of say 40 employees and the employee #
Worksheet B contains a master list of all employee #'s
I am trying to verify if the names on worksheet A contain the correct employee #. I am trying not look them up individually.
How can I use vlookup for this? Basically, I want it to return a bad employee #.
Worksheet B contains a master list of all employee #'s
I am trying to verify if the names on worksheet A contain the correct employee #. I am trying not look them up individually.
How can I use vlookup for this? Basically, I want it to return a bad employee #.
