Hello,

I currently have a work schedule layed out bi-weekly for 18 employees on Sheet1 for the full year.

On sheet2 I want to create a drop down slecetion for the bi-weekly work schedule, so that it would populate the employee schedule below. I want to see that when I select "Week 1-2" that it will display the data from Sheet1 on Sheet2. I have been trying to use VLOOKUP with no success.