Look up date based on column value

[dan_b]

Hello,

I'm trying to find a way to look up the date within the same sheet based on the value of a column. In the spreadsheet below, I want to find the end date of the phase listed in column C for each employee. The dates for each phase are listed in column F. 

Thanks!

[MarqueeCrew]

To find the MAXIMUM END Date by Current Phase for an employee,

I would use a summarize tool configured as:

GroupBy [Employee#]

GroupBy [Current Training Phase]

Max [End Date]

You could JOIN that data (right side of join) to the original data (left side of join) on:

Left Employee # = Right Employee #

Left Current Training Phase = Right Current Training Phase

That will populate MAX_End Date on the data.

I'm not certain by your question if this is exactly what you want, but it should help you get to your answer.

Thanks,

Mark

[dan_b]

Thanks for the response.

That gave me the Date, but I need the date listed on each row in Column C. 

 

[MarqueeCrew · Accepted solution]

Hi @dan_b,

Here is a module to help you (with some tweaks to my pseudo-code:

[dan_b]

This works! Thank you!