Results 1 to 4 of 4

Having trouble making a function that returns multiple values for index match.

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Minneapolis MN
    MS-Off Ver
    2016
    Posts
    2

    Having trouble making a function that returns multiple values for index match.

    Currently trying to create an index function that returns multiple values horizontally. Currently when I run this formula using ctrl + shift + enter I get an #N/A

    Current formula: =INDEX($B$2:$B$150, SMALL(IF(A$2=$C$2:$C$150, ROW($C$2:$C$150)-MIN(ROW($C$2:$C$150))+1, ""), COLUMN(A1)))


    Ideally cell D2 would be cgsteen
    Attached Files Attached Files
    Last edited by bhlynch98; 07-12-2019 at 11:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match function returns #NA
    By limpfisch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2018, 11:39 AM
  2. Index Match that returns all non zero values in row
    By kvarner in forum Excel Formulas & Functions
    Replies: 44
    Last Post: 03-03-2016, 06:41 PM
  3. [SOLVED] Index+Match+Match doesnt returns right values
    By SwissExcel in forum Excel General
    Replies: 10
    Last Post: 07-21-2015, 08:39 AM
  4. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  5. Index Match Function Multiple Values
    By mpagliaro in forum Excel General
    Replies: 3
    Last Post: 03-10-2015, 10:29 AM
  6. [SOLVED] Making a Dynamic Invoice That looks up a value and returns multiple corresponding values
    By david_j_p in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2013, 01:40 AM
  7. INDEX(...MATCH(IF...))) Function trouble
    By reaper_2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-25-2011, 02:19 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