I have an Excel worksheet with two tabs, Tab 1 has a list of employees with information on different courses they've taken. Among them is a tab with a 5 digit employee ID to easily identify them..
On Tab 2 is a list of employees who took a course we'll call "Intro". This tab has an employee ID column as well as a "course date" column.
In the Tab 1, there's a column for course Intro where the date can be entered.
What I'm trying to do is have Tab 1 search the employees IDs on Tab 2 and if there is a match, grab the course date from that row and paste it into the column for Course Intro in Tab 1.
It seems like it should just be a VLOOKUP and then say "if you find this, then grab this cel and paste it over here"... but having a heck of a time!