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!
Bookmarks