Forum Discussion

Hugo_Coetzee's avatar
Hugo_Coetzee
Copper Contributor
Apr 02, 2024

Autofill name list if multiple conditions match

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:

 

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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

Resources