Autofill name list if multiple conditions match

[Hugo_Coetzee]

Hello

Please assist with the following problem.

I want to extract the Names in Colom B based on the values in Colom E & S into an auto populating list on a separate sheet based on the criteria values on that sheet.

Data Sheet:

List sheet with requirements:

[#2]

@Hugo_Coetzee 

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

How I provide more Details.

Thank you for your understanding and patience