Is it possible to make the row lookup array/range part of this formula variable so that it is first defined by finding a match in a headings column?
=IFERROR(INDEX(BOXES!$A$6:$BY$26,SMALL(IF(BOXES!$AL$6:$AL$26>0,ROW(BOXES!$AL$6:$AL$26)-ROW(BOXES!$AL$6)+1),ROWS(E51:E$51)),MATCH(E$5,BOXES!$A$5:$BY$5,0)),0)
I.e. The BOXES!$AL$6:$AL$26 and BOXES!$AL$6 bits would become for example BOXES!$AM$6:$AM$26 and BOXES!$AM$6 if a match was first found in AM5 (in range AL5 to BY5).
Can't see anything online like this so all help will be great!
Thanks.
Bookmarks