Trying to lookup a certain row in a table and then compare two numbers within that row. Essentially perform a lookup formula and then perform an IF statement.
To elaborate, I am an officer in a college club that run various tabletop games in different rooms. I am trying to keep an organized list of games that are occurring. I have a list of all of the games that are happening (first picture), but I am trying to separate the games based on week. I am trying to determine automatically whether or not a certain game as availability, and to list either true or false in a separate table on a separate sheet (second picture).
I currently have all of the information sorted by using the FILTER function, if there is a better way to keep the information organized that may solve this issue better than what I’m trying to do, I’m all ears.
Also, please excuse missing data. I haven’t gotten around to working on date formatting yet.
This is the master list of all of the games:
And this is the filtered list for A week games:
