LIST BASED ON MULTIPLE CRITERIA

[MariaMcK]

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

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[MariaMcK]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

PRO 2019

 

[Fluff]

Thanks for that.
How about in A8 dragged down

=IFERROR(INDEX(Sheet2!$E$2:$E$100,AGGREGATE(15,6,(ROW(Sheet2!$E$2:$E$100)-ROW(Sheet2!$E$2)+1)/(Sheet2!$A$2:$A$100=$B$3)/(Sheet2!$F$2:$F$100=$B$5),ROWS(A$8:A8))),"")

 

[MariaMcK]

Thanks for that.
How about in A8 dragged down

=IFERROR(INDEX(Sheet2!$E$2:$E$100,AGGREGATE(15,6,(ROW(Sheet2!$E$2:$E$100)-ROW(Sheet2!$E$2)+1)/(Sheet2!$A$2:$A$100=$B$3)/(Sheet2!$F$2:$F$100=$B$5),ROWS(A$8:A8))),"")

Perfect! thank you - I appreciate you!

 

[Fluff]

Glad to help & thanks for the feedback.