@Paul Newcome @Andrée Starå
I am having issues matching a cell value from my project status column. My goal is to reference my most recently updated (max modified cell) data entry and return that value in the selected cell.
My current formula for reference:
=INDEX([Project (Schedule) Status]3: [Project (Schedule) Status]54, MATCH ([Project (Schedule) Status @row], MAX([Modified3] : [Modified54])))
The value returned is #UNPARSEABLE
I need direction on this issue I have no clue where my issue arises.
See attached for picture reference, the columns I am working with are the two furthest to the right