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:
- On the X axis I have User 1, User 2, User 3, etc
Note that the Y-axis lines are repeated several times with the same date but with different coursenames being run per day.
- On the Y axis I have Date, AM/PM Session and Coursename
So I would like to report from this table into another table (on a different sheet) with the following format:
- 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?)
Without looking at your attachments, it would be more convenient if you want help with Excel to post a workbook rather than pictures.
Hi I've uploaded the file - in the form of a zip. Please advise. Thanks
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1