Results 1 to 6 of 6

INDEX formula error - using SMALL, ROW, MIN

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2016
    Location
    Indianapolis, Indiana
    MS-Off Ver
    2010
    Posts
    36

    INDEX formula error - using SMALL, ROW, MIN

    I have a formula that is meant to go through a column of data and pull every match to the searched number. I then have an array where it pulls the corresponding data (Looks in column A and returns column C, etc.). So it needs to find the first match and all it's data, the second match and it's data, etc. However right now it is not pulling ALL matches. It is pulling a random (?) number of them. The complex formula is:

    =IFERROR(IF(INDEX(Data!J$2:J$20000,SMALL(IF($A$2=Data!$A20:$A$20000,ROW(Data!$A20:$A$20000)-MIN(ROW(Data!$A$2:$A$20000))+1,"")ROW(Data!$A20)))=0,"Not available",INDEX(Data!J$2:J$20000,SMALL(IF($A$2=Data!$A20:$A$20000,ROW(Data!$A20:$A$20000)-MIN(ROW(Data!$A$2:$A$20000))+1,""),ROW(Data!$A20)))),"")

    The heart of the formula is :
    INDEX(Data!J$2:J$20000,SMALL(IF($A$2=Data!$A20:$A$20000,ROW(Data!$A20:$A$20000)-MIN(ROW(Data!$A$2:$A$20000))+1,"")

    Any ideas?
    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] ask formula index+small + if
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2015, 04:29 AM
  2. Index Small Row Formula
    By davidcharis16 in forum Excel General
    Replies: 3
    Last Post: 04-16-2015, 04:40 AM
  3. [SOLVED] VBA instead of index small or vlookup formula
    By cajand in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-25-2014, 05:29 PM
  4. Error using Array: Index, Small, Row to pull list from PivotTable
    By lgnmag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-25-2014, 08:39 PM
  5. [SOLVED] Index range small row - num error
    By Trax in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-13-2013, 09:18 AM
  6. Can't find the error functions INDEX () and SMALL()
    By HyperG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2012, 12:20 AM
  7. INDEX SMALL ROW Formula #REF! error.
    By elcasey125 in forum Excel General
    Replies: 3
    Last Post: 12-10-2008, 12:41 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