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. 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. Since my 16 tables are separate, can you please write the formula I would use for example for readings-current topics in the master table. NOTE: I ALREADY POSTED THIS AND WAS JUST TOLD WHAT VLOOK IS. I KNOW WHAT IT IS BUT THAT DOES NOT HELP ME IN MY CASE. PLEASE LOOK AT MY PICTURES AND TELL ME HOW I SHOULD PROCEED IN MY SPECIFIC CASE.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started