I'm brand new at working with the INDEX and MATCH functions, but I think they are the key to what I'm trying to do.
I'm tracking meetings for a number of sales people. I'm using 2 tabs for different types of sales, each tab listing the date of a sales meeting and adjacent, the name of the company. With hundreds of entries now, I wanted to add an INDEX to a summary page that will return results for meetings that happened in the last week and another for those set for the following week.
I've uploaded a sample spreadsheet. I played around with a few things before posting but couldn't find a close enough match in other threads to really get a handle on this. Thanks in advance for any help!
example worksheet.xlsx
Bookmarks