I'm attempting to search values from a set of data that's downloaded every day. Example below. I need to find out how much of item category (food or bev) was sold during lunch and dinner in both the bar and the dining room. I tried using index match but I'm having trouble since there essentially 2 tables located on top of each other.
Things to note:
1. The format sucks, I know. But it is downloaded this way...
2. Goal is to pull data from "Feb-26" (daily tab) to the "Week 1" tab.
3. There are 3 criteria
Meal time: Lunch or Dinner (There sometimes are more)
Revenue Center: Bar or Dining Room (There sometimes are more)
Item Category: Food or Beverage
Can you suggest a formula I could use to scan all the data and find the correct values?
The range I'd be searching for, Bar or Dining room, would always begin with the cell containing Bar/Dining Room and end with the cell containing "Total Net Sales". Could I somehow define the range using that and then use index/match?
example.xlsx
Bookmarks