XLOOKUP multiple tables

Copper Contributor

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 the classes on the 2nd sheet of the excel document to pull the correct dates and corresponding information.  

5 Replies







Is there a way to keep the classes together? All the A classes together and all the B classes together etc?
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.


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?