Results 1 to 14 of 14

Multiple Match/Index for Individual Tabs

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2015
    Location
    California
    MS-Off Ver
    Mac 2011
    Posts
    25

    Angry Multiple Match/Index for Individual Tabs

    Hey everyone!

    Having a major brain fart.

    First off, here is the link to the workbook I am working with: This is a Google Sheet (I know, I want it in Excel but several people that will need access to this do not have Excel) https://docs.google.com/spreadsheets...it?usp=sharing

    What I am trying to accomplish is for the data to pull from the 'Business by Rep' sheet to the corresponding Rep sheet. For example, Test 1 is Hart's business so it should only display on his tab.

    I hope this makes sense, I think a nested If should work, but not really getting it to display multiple results like I want.

    I do have a formula that works and shows the first result, but I can't get it to show multiple results properly

    Thanks in advance everyone!
    Last edited by hartjohnson; 07-11-2016 at 03:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. trying use index match to pull information from database to individual sheet
    By garvey1973 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2015, 07:33 PM
  2. Index Match Across Multiple Tabs?
    By ratherbeknitting in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2015, 11:46 PM
  3. Index Match Across Tabs
    By tryingtoexcelatexcel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2015, 01:41 AM
  4. Item Match between TABS (Index,Match???)
    By jespo1351 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-02-2014, 03:28 PM
  5. Match Index from Data sheet to Individual Sheet
    By dawnmau in forum Excel General
    Replies: 5
    Last Post: 06-21-2010, 02:47 PM
  6. Index & Match - Individual Cells
    By Harlequin in forum Excel General
    Replies: 4
    Last Post: 08-16-2007, 11:24 AM

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