Results 1 to 5 of 5

ARRAY/PIVOT + duplicates - need to return multiple match values

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2016
    Location
    London
    MS-Off Ver
    Office 2013
    Posts
    6

    ARRAY/PIVOT + duplicates - need to return multiple match values

    Attempting to achieve the following. Best that i show you!

    multiple-matches.png

    I'm most confused about the yellow cell, as there is no data validation applied. You just type the animal, and
    it gives you the matches. Neither is there any formula, or it's hidden?

    My table looks like this:

    data1.PNG

    I created a pivot table, since i had duplicate values in the "EXPENSES" column,
    and i didn't want to have duplicates showing up in the data validation list ("Expense" column).

    data2.PNG

    If there's a better way to do it - PLEASE, let me know.

    Now the problem is, that when i choose a certain expense, for example cleaning,
    i want the Code column (w/ three question marks) to generate all the codes associated with cleaning.

    VLOOKUP or INDEX only gives the first result. I need them all, so i have to use ARRAY FORMULA?

    data3.PNG

    This is where it gets tricky. I'm a beginner so this is all new to me. I'd be thankful for any kind of help!

    Download my table:
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Array Match and Return value upon multiple array match criteria
    By VegetaOSX in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 05:50 AM
  2. Use Index/Match Function to Return Values from an Array
    By 00pumpkin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2013, 02:22 PM
  3. [SOLVED] Complex Match return array of values
    By sfluegge in forum Excel General
    Replies: 4
    Last Post: 05-01-2012, 10:55 AM
  4. Find a value in an array and return multiple values in an adjacent array
    By tonbra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2012, 08:35 PM
  5. Replies: 5
    Last Post: 04-04-2005, 05:06 PM

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