+ Reply to Thread
Results 1 to 4 of 4

Indexing and matching multiple cells to one

  1. #1
    Registered User
    Join Date
    07-23-2015
    Location
    New York City
    MS-Off Ver
    2016 for Mac
    Posts
    6

    Indexing and matching multiple cells to one

    Hey guys,

    I have a list of agents on a spread sheet called "Agents" and I want to search a worksheet called "MASTER" to find the clients represented by the agent.

    The idea:
    On Agents sheet in F2 I would write a formula like "Look up vale A2 in sheet "MASTER" search column P (fir the agent name), return values in column B that match separated by commas"

    Any ideas?

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Indexing and matching multiple cells to one

    It looks like a typical use of a Pivot Table.
    Attach a sample file to prepare it.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    07-23-2015
    Location
    New York City
    MS-Off Ver
    2016 for Mac
    Posts
    6

    Re: Indexing and matching multiple cells to one

    I don't want to use a pivot table because I want to be able to run a mail merge of the agents sheet.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Indexing and matching multiple cells to one

    Try next UDF

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by PCI; 07-23-2015 at 03:08 PM. Reason: Typo

+ 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. Indexing with Multiple Criteria and Blank Cells
    By timtomm66 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2014, 02:52 PM
  2. Indexing and matching cells across two sheets
    By Rebecca Gillon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-27-2013, 11:18 AM
  3. Indexing and Matching
    By Puth2012 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-16-2013, 11:28 AM
  4. Indexing and matching data from date range and matching
    By Rickomicko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2013, 11:46 AM
  5. [SOLVED] Matching and Indexing Multiple Columns
    By tim220225 in forum Excel General
    Replies: 10
    Last Post: 03-29-2012, 07:26 AM
  6. Multiple Matching and indexing with null logic
    By jcorcoran in forum Excel General
    Replies: 2
    Last Post: 10-23-2011, 11:28 AM
  7. Indexing and matching multiple criteria
    By Dbeethekidd in forum Excel General
    Replies: 8
    Last Post: 09-02-2009, 08:22 AM

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