Referencing a second Criteria within INDEX and MATCH

Hello,

I've been looking at this problem for too long, and can't seem to find the correct way to solve it.
I've attached a sheet with the problem.

I have one sheet which summarises the status of documents in another sheet.
I'm using INDEX and MATCH to return the correct Document title and info.
But I need to offset/countif/INDEX MATCH again or something to get to reference the latest revision status of the document.

Any help would be appreciated.