Results 1 to 2 of 2

Array Lookup Formula Help Needed

Threaded View

rgrov004 Array Lookup Formula Help... 12-11-2012, 02:31 PM
DonkeyOte Re: Array Lookup Formula Help... 12-22-2012, 10:49 AM
  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Array Lookup Formula Help Needed

    In the Promised Column in Sheet 1 the array formula needed should start giving the value when the ordered column is no longer giving answers. It is currently doing this, but within the formula in the SMALL function I need it to recognize when the ordered column has stopped giving a numbered response and in that first cell have ROW(1:1), for example K13 should essentially be giving:

    {=IF(I11="-",IF(ISERROR(INDEX('Future SO''s'!$B:$F,SMALL(IF('Future SO''s'!$B:$B=$D$5,ROW('Future SO''s'!$B:$B)),ROW(1:1)),5)),"",INDEX('Future SO''s'!$B:$F,SMALL(IF('Future SO''s'!$B:$B=$D$5,ROW('Future SO''s'!$B:$B)),ROW(1:1)),5)),"-")}

    Instead of ROW(5:5). I need this because when it starts searching in Row(5:5) instead of Row(1:1) it skips over some of the data it is searching for in ROW's 1-4.

    Any help on this will be greatly appreciated, I've seen to have come to a sudden halt when trying to figure this out. Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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