XLOOKUP multiple tables

Question

I am trying to create a snapshot of classes that are in session or going to be in session for the next 8 weeks.&nbsp; 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.&nbsp;&nbsp;

patrick2788 · Answer

removed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

kupka8 · Answer

Is there a way to keep the classes together? All the A classes together and all the B classes together etc?

kupka8 · Answer

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.

patrick2788 · Answer

removed

kupka8 · Answer

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?

Forum Discussion

XLOOKUP multiple tables