Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 198
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi,
Is there a formula that can look up both WE dates and match the category to give you the labour cost? The first row shows the result I'm after.
Thank you.
<colgroup><col style="mso-width-source:userset;mso-width-alt:4571;width:94pt" width="125"> <col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> </colgroup><tbody>
[TD="width: 125, align: center"]Production
[/TD]
[TD="width: 112, align: center"][/TD]
[TD="width: 137, align: center"][/TD]
[TD="width: 35, align: center"][/TD]
[TD="class: xl35746, width: 109, align: center"]Category[/TD]
[TD="width: 92, align: center"][/TD]
[TD="width: 111, align: center"][/TD]
[TD="width: 97, align: center"][/TD]
[TD="width: 144, align: center"][/TD]
[TD="width: 93, align: center"][/TD]
[TD="width: 113, align: center"][/TD]
[TD="class: xl35744, width: 125, align: center"]WE Date
[/TD]
[TD="class: xl35744, width: 112, align: center"]Category
[/TD]
[TD="class: xl35745, width: 137, align: center"]Labour Cost
[/TD]
[TD="align: center"][/TD]
[TD="class: xl35743, align: center"]WE Date[/TD]
[TD="class: xl35743, align: center"]Day 1[/TD]
[TD="class: xl35743, align: center"]Day 2[/TD]
[TD="class: xl35743, align: center"]Day 3[/TD]
[TD="class: xl35743, align: center"]Day 4[/TD]
[TD="class: xl35743, align: center"]Day 5[/TD]
[TD="class: xl35743, align: center"]Day 6[/TD]
[TD="class: xl35747, align: center"]Sun 19/11/17[/TD]
[TD="class: xl35748, align: center"]Day 3[/TD]
[TD="class: xl35758, align: center"]$1.15[/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35747, align: center"]Sun 19/11/17[/TD]
[TD="class: xl35750, align: center"]$1.55[/TD]
[TD="class: xl35750, align: center"]$1.65[/TD]
[TD="class: xl35750, align: center"]$1.15[/TD]
[TD="class: xl35750, align: center"]$2.95[/TD]
[TD="class: xl35750, align: center"]$2.19[/TD]
[TD="class: xl35750, align: center"]$1.02[/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17
[/TD]
[TD="class: xl35752, align: center"]Day 4[/TD]
[TD="class: xl35759, align: center"]??[/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17[/TD]
[TD="class: xl35753, align: center"]$1.20[/TD]
[TD="class: xl35753, align: center"]$1.74[/TD]
[TD="class: xl35753, align: center"]$0.95[/TD]
[TD="class: xl35753, align: center"]$1.98[/TD]
[TD="class: xl35753, align: center"]$2.45[/TD]
[TD="class: xl35753, align: center"]$1.65[/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17[/TD]
[TD="class: xl35752, align: center"]Day 3[/TD]
[TD="class: xl35759, align: center"]??
[/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35753, align: center"]$1.10[/TD]
[TD="class: xl35753, align: center"]$1.61[/TD]
[TD="class: xl35753, align: center"]$0.75[/TD]
[TD="class: xl35753, align: center"]$1.75[/TD]
[TD="class: xl35753, align: center"]$1.95[/TD]
[TD="class: xl35753, align: center"]$2.93[/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35754, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35755, align: center"]$1.50[/TD]
[TD="class: xl35755, align: center"]$1.25[/TD]
[TD="class: xl35755, align: center"]$1.65[/TD]
[TD="class: xl35755, align: center"]$1.38[/TD]
[TD="class: xl35755, align: center"]$1.75[/TD]
[TD="class: xl35755, align: center"]$1.73[/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 6[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 6[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 2[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35752, align: center"]Day 3[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35756, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35757, align: center"]Day 5[/TD]
[TD="class: xl35760, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
</tbody>
Is there a formula that can look up both WE dates and match the category to give you the labour cost? The first row shows the result I'm after.
Thank you.
<colgroup><col style="mso-width-source:userset;mso-width-alt:4571;width:94pt" width="125"> <col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> </colgroup><tbody>
[TD="width: 125, align: center"]Production
[/TD]
[TD="width: 112, align: center"][/TD]
[TD="width: 137, align: center"][/TD]
[TD="width: 35, align: center"][/TD]
[TD="class: xl35746, width: 109, align: center"]Category[/TD]
[TD="width: 92, align: center"][/TD]
[TD="width: 111, align: center"][/TD]
[TD="width: 97, align: center"][/TD]
[TD="width: 144, align: center"][/TD]
[TD="width: 93, align: center"][/TD]
[TD="width: 113, align: center"][/TD]
[TD="class: xl35744, width: 125, align: center"]WE Date
[/TD]
[TD="class: xl35744, width: 112, align: center"]Category
[/TD]
[TD="class: xl35745, width: 137, align: center"]Labour Cost
[/TD]
[TD="align: center"][/TD]
[TD="class: xl35743, align: center"]WE Date[/TD]
[TD="class: xl35743, align: center"]Day 1[/TD]
[TD="class: xl35743, align: center"]Day 2[/TD]
[TD="class: xl35743, align: center"]Day 3[/TD]
[TD="class: xl35743, align: center"]Day 4[/TD]
[TD="class: xl35743, align: center"]Day 5[/TD]
[TD="class: xl35743, align: center"]Day 6[/TD]
[TD="class: xl35747, align: center"]Sun 19/11/17[/TD]
[TD="class: xl35748, align: center"]Day 3[/TD]
[TD="class: xl35758, align: center"]$1.15[/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35747, align: center"]Sun 19/11/17[/TD]
[TD="class: xl35750, align: center"]$1.55[/TD]
[TD="class: xl35750, align: center"]$1.65[/TD]
[TD="class: xl35750, align: center"]$1.15[/TD]
[TD="class: xl35750, align: center"]$2.95[/TD]
[TD="class: xl35750, align: center"]$2.19[/TD]
[TD="class: xl35750, align: center"]$1.02[/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17
[/TD]
[TD="class: xl35752, align: center"]Day 4[/TD]
[TD="class: xl35759, align: center"]??[/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17[/TD]
[TD="class: xl35753, align: center"]$1.20[/TD]
[TD="class: xl35753, align: center"]$1.74[/TD]
[TD="class: xl35753, align: center"]$0.95[/TD]
[TD="class: xl35753, align: center"]$1.98[/TD]
[TD="class: xl35753, align: center"]$2.45[/TD]
[TD="class: xl35753, align: center"]$1.65[/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17[/TD]
[TD="class: xl35752, align: center"]Day 3[/TD]
[TD="class: xl35759, align: center"]??
[/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35753, align: center"]$1.10[/TD]
[TD="class: xl35753, align: center"]$1.61[/TD]
[TD="class: xl35753, align: center"]$0.75[/TD]
[TD="class: xl35753, align: center"]$1.75[/TD]
[TD="class: xl35753, align: center"]$1.95[/TD]
[TD="class: xl35753, align: center"]$2.93[/TD]
[TD="class: xl35751, align: center"]Sun 26/11/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35754, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35755, align: center"]$1.50[/TD]
[TD="class: xl35755, align: center"]$1.25[/TD]
[TD="class: xl35755, align: center"]$1.65[/TD]
[TD="class: xl35755, align: center"]$1.38[/TD]
[TD="class: xl35755, align: center"]$1.75[/TD]
[TD="class: xl35755, align: center"]$1.73[/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 6[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 6[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 03/12/17[/TD]
[TD="class: xl35752, align: center"]Day 2[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35752, align: center"]Day 3[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35751, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35752, align: center"]Day 1[/TD]
[TD="class: xl35759, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35756, align: center"]Sun 10/12/17[/TD]
[TD="class: xl35757, align: center"]Day 5[/TD]
[TD="class: xl35760, align: center"] [/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
[TD="class: xl35749, align: center"][/TD]
</tbody>