I need to create a single column list from a worksheet that I will update weekly. The columns will all be the same when I import, some of the data may chance. I need to pull the list of names from that worksheet that meet 2 criteria. The criteria is located in a different worksheet. I've tried filter, index, and a number of other suggestions I found on the web but all are giving me errors that my argument is invalid. I'm at a loss. I've attached a screenshot to explain what I want. I'd prefer that when I update sheet 2 weekly it recognizes there may be more rows than the previous (I did try using A:A but it again didn't work). I really love learning and usually find what I need by searching, but all the tutorials have failed me