Hello,

I need to create a consolidated table for the current date that matches the PC on one sheet and lists all the jobs worked for that PC for today's date.

The date in the Man Hours sheet starts on Row 5 and ends on Row 900 in Column A and needs to match the date on the SOCAL Daily Site Analysis sheet Cell C4
The PC in the Man Hours sheet starts on Row 5 and ends on Row 900 in Column D and needs to match the PC on the SOCAL Daily Site Analysis sheet Cell B3
The end result would be a list of sites (A consolidated list, no duplicates) from the Man Hours sheet (Column I, Rows 5 thru 900I to populate the SOCAL Daily Site Analysis sheet

I tried piecing the following formula together and I am not getting any positive results.

{=IFERROR(INDEX('Man Hours'!I$5:I$900,MATCH(IF('Man Hours'!$D$5:$D$900=322001,AND('Man Hours'!$A$5:$A$900=$C$4,ROW('Man Hours'!I$5:I$900))),""}

Any help would be greatly appreciated.

Signed,

Formulatically Challenged