Vloop / Match / index - Search for results in rows

[KP007]

Please help me. I hope I explain this correctly. I have attached 2 sheets that I am currently working with. The first sheet has all the relevant information for employees.

In the second sheet, I need a list of all employees with a value of 0 sales on each date.

The user selects a date via a drop-down list or mixed date and using the date, it must draw all information from sheet 1 with all employees with the value of 0 and list them one below the other.

 

[Zot]

Image is not viewable

Please learn how to use XL2BB Add-In. Helper will be happier to be able to copy worksheet as it is. Look for this icon

and click it

 

[KP007]