+ Reply to Thread
Results 1 to 3 of 3

Referencing data from any cell within a table using multiple criteria to call off val

  1. #1
    Registered User
    Join Date
    06-19-2008
    Posts
    2

    Referencing data from any cell within a table using multiple criteria to call off val

    Hi, hope someone can help.

    I have a training schedule spreadsheet that I'm trying to report from:

    Table A:
    • On the X axis I have User 1, User 2, User 3, etc
    • On the Y axis I have Date, AM/PM Session and Coursename
    Note that the Y-axis lines are repeated several times with the same date but with different coursenames being run per day.

    So I would like to report from this table into another table (on a different sheet) with the following format:

    Table B:
    • On the X axis I have 2 intances of the same date per date - the first instance represents AM and the second PM
    • On the Y axis I have the total username list

    What I want is to reference any cell in Table B (using username, date and AM/PM) to interrogate the same values in Table A to get the coursename (held in the second column).

    Quite tricky to describe this - hope I haven't lost you! I've attached a couple of screenshots of Table A and Table B.

    I've tried VLOOKUP but it only references from a single column as opposed to a whole table.

    Any ideas? (or Queries?)

    Priyesh
    Attached Images Attached Images

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Without looking at your attachments, it would be more convenient if you want help with Excel to post a workbook rather than pictures.

  3. #3
    Registered User
    Join Date
    06-19-2008
    Posts
    2

    Uploaded Excel

    Hi I've uploaded the file - in the form of a zip. Please advise. Thanks
    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)

Bookmarks

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