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!
2 Answers
Sheet 1 data
1 name 1 2 name 2 3 name 3 4 name 4 5 name 5 6 name 6 Sheet 2 data
name 3 today name 4 Yesterday name 5 a different day name 6 tomorrow name 7 never Query in cell C1 of sheet 1, copie and paste down
=VLOOKUP(B1,Sheet2!A:B,2,FALSE)
Results
1 name 1 #N/A 2 name 2 #N/A 3 name 3 today 4 name 4 Yesterday 5 name 5 a different day 6 name 6 tomorrow Try something like this =VLOOKUP(Tab2!ID,IDtable,2,False) Where IDtable has the ID's in column 1 and course dates in column 2. Also change Tab2!ID to the relevant cell in Tab 2.
