Finding Out What Phase A Project Is In (Example Att) ?

[dvent]

Hi All,

I have attached an example spreadsheet to assist with this.

I have a list of projects in Column A (1 to 7).

They all have dates and data in the associated rows. I want to know in Column L what Phase the project is currently in?

This will be defined by a) the Phases listed in row 1 and b) if the project has any information furthest to the right in its row i.e. if there is info in Row K its Phase C, row H = Phase 2 etc.

Can anyone help with this?

Thanks
dvent