+ Reply to Thread
Results 1 to 1 of 1

Index/Match Help - Google Sheets

  1. #1
    Registered User
    Join Date
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007

    Index/Match Help - Google Sheets

    Hi There!

    Everyone in this forum is so fantastic and I'm hoping someone can help again.

    I have a spreadsheet that I'm trying to use a billing tab to populate a summary tab. On the attached spreadsheet - I want to populate the Schedule Summary tab, with the sales person's name on the appropriate date they've signed up for based on the May Tab. I've also added a desired result tab as an example of what I wanted it to look like.

    I've been able to get it to work for one line by using this formula -
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    but when I copy it down, it doesn't work properly for the next results - it gives me blank cells, instead of finding the next hit that meets the requirements.

    I'm guessing I need to use an index/match formula, but haven't been able to get it to work. I've also tried this formula, but it did not work, it gave me a result of "0".
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Also to note - the attachment is in Excel, but I need it to work in google sheets.

    Help Please!

    Thank you!!!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  2. Replies: 1
    Last Post: 06-18-2015, 08:45 AM
  3. Grab next same value in Excel/Google Sheets for RANK/MATCH formula
    By jpsear in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2015, 07:52 PM
  4. Replies: 0
    Last Post: 12-03-2014, 05:10 PM
  5. [SOLVED] Index Match using two sheets for Criteria to Match
    By Locust in forum Excel General
    Replies: 3
    Last Post: 12-01-2013, 12:45 PM
  6. Multiple Sheets Match & Index filtering by sheets
    By ijulian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-24-2012, 01:49 PM
  7. Index and match value from specified sheets?
    By gaftalik in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-30-2008, 03:40 AM


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