Index Match 3 Way Look Up

[hiker8117]

I am trying to pull Labor Dollars from Sheet1 into Sheet2 by using a 3 way lookup Index and Match Function.
The 3 criteria are JO, TSTSD and KO. Any help is appreciated. Thank you Gene

Sheet2

TSTSD JO KO Labor Hours Total Dollars JMR9 828MQ20495 001 354 0 JIJ7 828MR60770 010 270 0 JMR9 828MR60770 020 206 0 <colgroup><col style="mso-width-source:userset;mso-width-alt:3766; width:77pt" width="103" span="2"> <col style="mso-width-source:userset;mso-width-alt:1755;width:36pt" width="48"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> </colgroup><tbody> </tbody>

<tbody>
</tbody>

Sheet1

JO TSTSD KO Labor Dollars 828MQ20495 JMR9 001 $15,843 828MR60770 JIJ7 010 $5,458 828MS41100 EEEW 009 $1,194 828MS41100 MFYX 008 $913 <colgroup><col style="mso-width-source:userset;mso-width-alt:3766; width:77pt" width="103" span="4"> </colgroup><tbody> </tbody>

<tbody>
</tbody>

<colgroup><col width="86"></colgroup><tbody>
</tbody>

<tbody> <colgroup><col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2194;width:45pt" width="60"> <col style="mso-width-source:userset;mso-width-alt:1499;width:31pt" width="41"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> </colgroup><tbody> </tbody> <tbody> </tbody> </tbody>

<tbody>
</tbody>

<tbody>
</tbody>

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

Review this:
https://exceljet.net/