index and match multiple columns on two different sheets

Hi,

I've got a problem where I am trying to return a value if two criteria from one table match two from another.

I have included a example of my issue.

=INDEX(Time!D:D,MATCH(Data!A2,Time!A:A,0)*AND(MATCH(Data!C2,Time!C:C,0)))

I have had a look around lots of forums but cant get my head around what is wrong with my formula


Thanks in advance of any help

Thanks for your help.

Would you mind explaining how this formula works?
For instance I dont really understand what this part of the formula is doing )-ROW(Time!$D$2)+1)))))

Thanks again

Thanks for your help.

I am having a liitle difficulty with using this formula on another sheet.
Please could you take a look and explain where ive gone wrong. Thanks