Lookup issue and multiple tables in one sheet
Oh hello there,
I have been working with a few different versions of this scheduling file and had been using one big table and now Im trying multiple tables per class. It's two different terms' schedules in one sheet "T1 T4" so I can see any scheduling conflicts and a second sheet "Lessons" with multiple tables, one per discipline. I have only been testing the first days morning block (B5:B9) before copying and pasting into the other blocks.
Here's what Im wondering, I am trying to do a vlookup into the notes section, based on what was selected in the Lesson cell(b6) but it only works with the first Glamour and Fashion classes because its the first table (or at least I think thats the issue)i
Is there a way to make the Instructor dropdown list and Room dropdown list flag a conflict or eliminate an option based on the selection from the same day/time block. For example, if you select "Ellen Ni" in Monday Morning for Term 1 it would eliminate her from the list for the Instructors list for Monday Morning Term4?
Also, I know theres a way to simplify things by naming the tables, would that be helpful too?
Ive attached the document, in case youre able to assist.
I know just enough about excel to know its possible but not enough to know how.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Karroog in forum Excel Charting & Pivots
Last Post: 10-21-2016, 10:13 AM
By AnnieParadis in forum Excel Programming / VBA / Macros
Last Post: 02-26-2016, 10:29 AM
By GeneralDisarray in forum Excel Programming / VBA / Macros
Last Post: 10-01-2014, 09:34 AM
By Mr.Mouse in forum Excel Formulas & Functions
Last Post: 07-15-2014, 04:12 AM
By sshahils in forum Excel General
Last Post: 05-10-2012, 10:38 AM
By ministerofdeath in forum Excel General
Last Post: 03-24-2009, 03:52 AM
By KG in forum Excel General
Last Post: 05-06-2005, 08:06 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1