Question: I am trying to make a digitalized planner through excel. I am having a little bit of a struggle. In my first sheet titled as

 I am trying to make a digitalized planner through excel. Iam having a little bit of a struggle. In my first sheet I am trying to make a digitalized planner through excel. I am having a little bit of a struggle. In my first sheet titled as Task Manager, I am attempting to create a master table where I can enter a week number and all my assignments for that week will pop up including any upcoming exams and quizzes for the week prior. I have created 17 tables in my second sheet titled Master List where it has all the information for each week with each class and task category. I attempted to use the VLOOKUP formula but I was kind of struggling. Please tell me what to do and in simple terms, I have tried everything to understand.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!