Lookup value based on the first cell of the row

[Miega]

Hi everyone,

I have a set of data specific to a WFM function in which my first column contains a list of names and the following columns are each a date (header) with a certain schedule.
I need to get this data into something like this: Lookup a specific date and excel should return to me all the names from that day.
Afterwards I would use the names to lookup how they are scheduled in that day.

So lets say i go to another sheet and want to bring all the names from 20.09 and afterwards, bring all the values those names have in that day.

I have uploaded an image. You could see on the left that i have covered up the names column.

Any ideas?
Thanks,

 

[dnorm]

Hi Miega

Not sure if this would help, but would not a pivot table work? you should be able to assign a set of splicers to that table and have it auto filter that way.
Splicers should allow for instant filter and report back.