Hi
I have two tables in separate tabs within a spreadsheet.
Table 1: 'EmpInfo'
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]REC[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]WT/PT[/TD]
[TD]Last Updated[/TD]
[TD]Reason for Update[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]01/01/2010[/TD]
[TD]02/02/2012[/TD]
[TD]PT[/TD]
[TD]02/02/2012[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]02/02/2012[/TD]
[TD]17/06/2015[/TD]
[TD]WT[/TD]
[TD]17/06/2015[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]18/06/2015[/TD]
[TD]24/01/2016[/TD]
[TD]WT[/TD]
[TD]24/01/2016[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]25/01/2016[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD]01/01/2017[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD]12/04/2017[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Table 2: 'UpdtInfo'
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]REC[/TD]
[TD]Last Updated[/TD]
[TD]Reason for Update[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]01/01/2011[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]01/01/2012[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[TD]02/02/2012[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]01/01/2013[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2[/TD]
[TD]01/01/2014[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]01/01/2015[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[TD]17/06/2015[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]3[/TD]
[TD]01/01/2016[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]24/01/2016[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]4[/TD]
[TD]01/01/2017[/TD]
[TD]201[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula that will drag the most recent date from column B in 'UpdtInfo' of the appropriate REC to 'EmpInfo'.
The same for the 'Reason for Update' code associated to the appropriate REC to be mirrored into 'EmpInfo'.
REC5 is an employment that commenced after the yearly update period (01/01/XXXX) so the cells in 'EmpInfo' for E6 and F6 need to be blank (I'd presume they'd remain blank anyway because there is no entry for REC5 in Table 2).
Could I ask for help on two formulas on these two problems pleeeease?
Thank you so very much kindly
I have two tables in separate tabs within a spreadsheet.
Table 1: 'EmpInfo'
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]REC[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]WT/PT[/TD]
[TD]Last Updated[/TD]
[TD]Reason for Update[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]01/01/2010[/TD]
[TD]02/02/2012[/TD]
[TD]PT[/TD]
[TD]02/02/2012[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]02/02/2012[/TD]
[TD]17/06/2015[/TD]
[TD]WT[/TD]
[TD]17/06/2015[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]18/06/2015[/TD]
[TD]24/01/2016[/TD]
[TD]WT[/TD]
[TD]24/01/2016[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]25/01/2016[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD]01/01/2017[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD]12/04/2017[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Table 2: 'UpdtInfo'
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]REC[/TD]
[TD]Last Updated[/TD]
[TD]Reason for Update[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]01/01/2011[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]01/01/2012[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[TD]02/02/2012[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]01/01/2013[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2[/TD]
[TD]01/01/2014[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]01/01/2015[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[TD]17/06/2015[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]3[/TD]
[TD]01/01/2016[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]24/01/2016[/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]4[/TD]
[TD]01/01/2017[/TD]
[TD]201[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula that will drag the most recent date from column B in 'UpdtInfo' of the appropriate REC to 'EmpInfo'.
The same for the 'Reason for Update' code associated to the appropriate REC to be mirrored into 'EmpInfo'.
REC5 is an employment that commenced after the yearly update period (01/01/XXXX) so the cells in 'EmpInfo' for E6 and F6 need to be blank (I'd presume they'd remain blank anyway because there is no entry for REC5 in Table 2).
Could I ask for help on two formulas on these two problems pleeeease?
Thank you so very much kindly