My table is on one sheet and the data is on another.
The data needs to be found for each person.
I know i need to use vlookup but not quite sure how to go about it.
It needs to:
1) check the week on the table,
2) go to the sheet that has the same name as the week
3) check the teacher on the table,
4) go to the teacher that is on that sheet
5) and take the information that is labeled "Total Hrs" (row 361) from the first collumn.
6) and have that number paste onto the table under actual hours.
If this is unclear please let me know.
Ive attached an example workbook.
Please help.
Bookmarks