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
[TABLE="width: 500"]
<tbody>[TR]
[TD]
<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>
[TD="class: xl69, width: 103"]TSTSD[/TD]
[TD="class: xl69, width: 103"]JO[/TD]
[TD="class: xl69, width: 48"]KO[/TD]
[TD="class: xl69, width: 89"]Labor Hours[/TD]
[TD="class: xl69, width: 103"]Total Dollars[/TD]
[TD="class: xl67"]JMR9
[/TD]
[TD="class: xl67"]828MQ20495[/TD]
[TD="class: xl67"]001
[/TD]
[TD="class: xl71"]354
[/TD]
[TD="class: xl70"]0[/TD]
[TD="class: xl68"]JIJ7
[/TD]
[TD="class: xl68"]828MR60770
[/TD]
[TD="class: xl68"]010
[/TD]
[TD="class: xl72"]270[/TD]
[TD="class: xl70"]0[/TD]
[TD="class: xl67"]JMR9
[/TD]
[TD="class: xl67"]828MR60770[/TD]
[TD="class: xl67"]020[/TD]
[TD="class: xl71"]206[/TD]
[TD="class: xl70"]0[/TD]
</tbody>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet1
[TABLE="width: 500"]
<tbody>[TR]
[TD]
<colgroup><col style="mso-width-source:userset;mso-width-alt:3766; width:77pt" width="103" span="4"> </colgroup><tbody>
[TD="class: xl67, width: 103"]JO
[/TD]
[TD="class: xl68, width: 103"]TSTSD[/TD]
[TD="class: xl68, width: 103"]KO[/TD]
[TD="class: xl69, width: 103"]Labor Dollars[/TD]
[TD="class: xl70"]828MQ20495
[/TD]
[TD="class: xl71"]JMR9
[/TD]
[TD="class: xl71"]001
[/TD]
[TD="class: xl72, align: right"]$15,843
[/TD]
[TD="class: xl73"]828MR60770
[/TD]
[TD="class: xl74"]JIJ7
[/TD]
[TD="class: xl76"]010
[/TD]
[TD="class: xl75, align: right"]$5,458[/TD]
[TD="class: xl70"]828MS41100
[/TD]
[TD="class: xl71"]EEEW[/TD]
[TD="class: xl77"]009[/TD]
[TD="class: xl72, align: right"]$1,194[/TD]
[TD="class: xl73"]828MS41100
[/TD]
[TD="class: xl74"]MFYX[/TD]
[TD="class: xl76"]008
[/TD]
[TD="class: xl75, align: right"]$913[/TD]
</tbody>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<colgroup><col width="86"></colgroup><tbody>
[TD="class: xl66, width: 86, align: center"][/TD]
</tbody>
<tbody>
[TD="class: xl68, width: 103"]
<tbody>
<tbody>
[TD="class: xl69, width: 60"][/TD]
[TD="class: xl69, width: 41"]
<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>
[TD="class: xl69, width: 60"][/TD]
[TD="class: xl69, width: 41"][/TD]
[TD="class: xl70, width: 103"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl78"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
</tbody>
[/TD]
[TD="class: xl70, width: 103"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl78"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
</tbody>
[TD="class: xl72"][/TD]
</tbody>
[/TD]
[TD="class: xl69, width: 103"]
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl72"][/TD]
</tbody>
<tbody>
[TD="class: xl66"][/TD]
</tbody>
The 3 criteria are JO, TSTSD and KO. Any help is appreciated. Thank you Gene
Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD]
<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>
[TD="class: xl69, width: 103"]TSTSD[/TD]
[TD="class: xl69, width: 103"]JO[/TD]
[TD="class: xl69, width: 48"]KO[/TD]
[TD="class: xl69, width: 89"]Labor Hours[/TD]
[TD="class: xl69, width: 103"]Total Dollars[/TD]
[TD="class: xl67"]JMR9
[/TD]
[TD="class: xl67"]828MQ20495[/TD]
[TD="class: xl67"]001
[/TD]
[TD="class: xl71"]354
[/TD]
[TD="class: xl70"]0[/TD]
[TD="class: xl68"]JIJ7
[/TD]
[TD="class: xl68"]828MR60770
[/TD]
[TD="class: xl68"]010
[/TD]
[TD="class: xl72"]270[/TD]
[TD="class: xl70"]0[/TD]
[TD="class: xl67"]JMR9
[/TD]
[TD="class: xl67"]828MR60770[/TD]
[TD="class: xl67"]020[/TD]
[TD="class: xl71"]206[/TD]
[TD="class: xl70"]0[/TD]
</tbody>
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet1
[TABLE="width: 500"]
<tbody>[TR]
[TD]
<colgroup><col style="mso-width-source:userset;mso-width-alt:3766; width:77pt" width="103" span="4"> </colgroup><tbody>
[TD="class: xl67, width: 103"]JO
[/TD]
[TD="class: xl68, width: 103"]TSTSD[/TD]
[TD="class: xl68, width: 103"]KO[/TD]
[TD="class: xl69, width: 103"]Labor Dollars[/TD]
[TD="class: xl70"]828MQ20495
[/TD]
[TD="class: xl71"]JMR9
[/TD]
[TD="class: xl71"]001
[/TD]
[TD="class: xl72, align: right"]$15,843
[/TD]
[TD="class: xl73"]828MR60770
[/TD]
[TD="class: xl74"]JIJ7
[/TD]
[TD="class: xl76"]010
[/TD]
[TD="class: xl75, align: right"]$5,458[/TD]
[TD="class: xl70"]828MS41100
[/TD]
[TD="class: xl71"]EEEW[/TD]
[TD="class: xl77"]009[/TD]
[TD="class: xl72, align: right"]$1,194[/TD]
[TD="class: xl73"]828MS41100
[/TD]
[TD="class: xl74"]MFYX[/TD]
[TD="class: xl76"]008
[/TD]
[TD="class: xl75, align: right"]$913[/TD]
</tbody>
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<colgroup><col width="86"></colgroup><tbody>
[TD="class: xl66, width: 86, align: center"][/TD]
</tbody>
<tbody>
[TD="class: xl68, width: 103"]
<tbody>
<tbody>
[TD="class: xl69, width: 60"][/TD]
[TD="class: xl69, width: 41"]
<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>
[TD="class: xl69, width: 60"][/TD]
[TD="class: xl69, width: 41"][/TD]
[TD="class: xl70, width: 103"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl78"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
</tbody>
[TD="class: xl70, width: 103"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl78"][/TD]
[TD="class: xl73, align: right"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76, align: right"][/TD]
</tbody>
</tbody>
[TD="class: xl69, width: 103"]
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl72"][/TD]
</tbody>
<tbody>
[TD="class: xl66"][/TD]
</tbody>