Return value from another column

I'm using lastnonblank to find a value in a table (all case statuses), but want to bring back the value in a different column in that same row.   The formula is   Year End Status = CALCULATE(    M...