Multiple criteria to find Shift pattern

[jet2004uk]

Hi Guys

I know this will be pretty simple for some, have played about with a Vlookup and Index and Match formulas, but not being smart as you guys I am here asking for some help.
Please see attached File

Match multiple criteria to find Shift pattern.

Thanks
J

[tim201110]

=lookup(i3,$a$3:$a$15/($b$3:$b$15=j3)/($c$3:$c$15=k3),$d$3:$d$15)

[jet2004uk]

Many thanks

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.