Forum Discussion
XLOOKUP multiple tables
I am trying to create a snapshot of classes that are in session or going to be in session for the next 8 weeks. I have a chart showing the classes, but I want a way to automatically search through t...
removed
- Is there a way to keep the classes together? All the A classes together and all the B classes together etc?
removed
- It is pulling classes that are starting one year out. It should be pulling classes A-001 - A-004, B-002 - B-010, C-001 - C-010 based off of the current date. Is there a way to do that?
- I want the classes that are happening in the current week to 8 weeks out, is there a way to do that? I don't want to show classes that are happening past those 8 weeks, or prior to the current week. I am trying to make a sheet that I can keep adding classes to as the months progress.