return the status description relating to the latest date in
Can anyone help with this one please?
I have attached a spreadsheet with the example of my problem.
The spreadsheet has:
* a row (2) of 'Status Description' headings
* columns (C-J) with dates of each occurrence of each status for a specific Job No.
* a column (L) showing the 'Latest date'
I need a formula to return the 'status description' (as text) relating to the latest date in Col 'L'
i.e. in cell 'M4', I need a formula that the latest date (09/07/2018) relates to the 'Status description' "Job Completed"
It's probably a simple answer, but I'm a novice at this.
If anyone can help, I would be grateful.
|