Look up date based on column value

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!

Common Use Cases

Accepted answers

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

Screen Shot 2016-09-29 at 11.46.46 AM.png

Lookup Date.yxmd

All comments

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

Thanks for the response.

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703