Lookups

Originally Posted by rolltyde12

When I insert more helper columns, everything on my formations page goes blank. Why is this. It's like it doesn't recognize that a column has been inserted.

This formula does not require helpper columns. Input formula in cell A2 in worksheet "Formations" and copied down.

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX(MASTER!$D$2:$D$163,SMALL(IF(ISNUMBER(SEARCH("Ac",MASTER!$D$2:$D$163)),ROW(MASTER!$D$2:$D$163)-ROW(A$2)+1),ROWS(A$2:A2)))))

The formula is an-array need to hold down:

Ctrl,Shift,Enter

Example below.