dynamic
3 TopicsCreating A Sublist
Trying to create a sub-list from a master list - currently working on two formulas: =INDEX('Client List'!B:B,MATCH("Chris",'Client List'!C:C,0)) This formula will pull the first cell that matches the criteria, but will not populate the rest =IFERROR(INDEX('Client List'!B:B,SMALL(IF('Client List'![AT Member 1]="Lindy",ROW('Client List'!)-1),ROW(1:1)),2),"") this formula will not workSolved3.7KViews0likes5Comments