Index Match using multiple criteria to match to

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

Hi,

Please post a sample template of your workbook using "Go Advanced" option.

I am trying to attach a sample workbook and I am getting a undefined permissions error. Am I doing something wrong or is there a special setting on my profile I need to change.

You said that equation doesn't get "any positive results". What exactly does that mean? What do you get when you use that formula? An error? Nothing?

It just displays the entire formula as a text entry. I am still unable to attach the workbook template.

Delete the array brackets at the beginning and end. To get an array, just type the regular formula and instead of hitting enter when you're done, hit ctrl+shift+enter. Then the array brackets will appear. Well, after you get the error saying you're missing a parenthesis.

I am getting a blank entry.

Then no data meet your requirement.