Extracting values based on multiple criteria

[Mama G]

I am new to creating complicated formulas and I hope I am saying this right. I need help extracting specific values to populate in specified fields on another worksheet based off of multiple criteria.

For example:
The employee has 2 Clients (Client 1 and Client 2).
The employee worked at 12:00 AM on 9/1/2016 for Client 1 then worked at 12:30 AM on the same day for Client 2.
On the second worksheet, I need the Client's name from the previous sheet to automatically populated according to the date and time they were worked the Client in the appropriate cell.

I have Excel 2010 but I need this done in Google Sheets so others will have access to view.

• The first image is where the data is coming from.
• The second image is where and how I need the data to populate.

Thank you in advance for any help that anyone can give.

 

[NARAYANK991]

Hi ,

It might help if you can upload a workbook with the data in it.

Narayan

 

[Mama G]

Hi ,

It might help if you can upload a workbook with the data in it.

Narayan

Here is the example/template that I am working with.
I left the formulas out because I got frustrated because nothing worked the way I needed it to. When I got close it said the answer was a text and I needed a number. I need the answer to be a text though. Please help.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Mama G]

Hi ,

See if this is OK.

Narayan

I LOVE YOU. THANK YOU, THANK YOU, THANK YOU

 

[Ufoo]

Narayan will you please unravel your formula? The highlighted portion has left me totally confused. Thanks a lot. =IFERROR(INDEX(ClientLabels, MATCH(1, (DateLabels = $A2) * (INDEX(Worked,, MATCH(B$1, TimeLabels, 0)) = "Worked"), 0)), "")