Results 1 to 7 of 7

Index - results in the last week/following week from 2 tabs

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Index - results in the last week/following week from 2 tabs

    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
    Last edited by FDibbins; 11-03-2012 at 02:13 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1