+ Reply to Thread
Results 1 to 1 of 1

Lookup issue and multiple tables in one sheet

  1. #1
    Registered User
    Join Date
    shanghai, china
    MS-Off Ver

    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.

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting into Pivot Tables - Having issue with Multiple Ranges
    By Karroog in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-21-2016, 10:13 AM
  2. Data validation allowing multiple choices - issue with Pivot tables
    By AnnieParadis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2016, 10:29 AM
  3. [SOLVED] strange protected sheet issue, refresh query tables
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2014, 09:34 AM
  4. [SOLVED] Lookup in multiple tables
    By Mr.Mouse in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-15-2014, 04:12 AM
  5. Replies: 2
    Last Post: 05-10-2012, 10:38 AM
  6. multiple lookup tables
    By ministerofdeath in forum Excel General
    Replies: 1
    Last Post: 03-24-2009, 03:52 AM
  7. Using Multiple LOOKUP tables
    By KG in forum Excel General
    Replies: 3
    Last Post: 05-06-2005, 08:06 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1