Pulling data from a search criteria

[Berandon]

I have a payroll google sheet for tracking labor to employees and customer's. There is a dropdown for customer information, and i know I want to search that information. But, i want it to return ALL Labor associated with that customer. So, if we paid someone 3 months apart, i want it to show all labor assigned to that customer record.

Here is a basic screenshot of what i am looking for. The data set I have is 3k+ lines and growing. The customer name and employee names are drop downs, so exact matching shouldn't be an issue. I have a pivot table for week by week breakdown for the bookkeeper, but trying by customer when there are thousands just seems messy. And i don't need it to stay populated, just search, report, and search the next.

I hope i am making some kind of sense and that there is a solution to my needs.

TIA

 

[jahanzaibriaz]

You can use FILTER function to do this. Put following formula into F6

=FILTER($A$3:$D$7, $A$4:$A$7=$F$3)