So I am trying to get the latest entry based on a column containing the timestamp, but I'm not getting my head around getting that entry without necessarily selecting that column.

update:

=INDEX(IFNA(VLOOKUP(C5:C&D5:D; 
 FILTER({'From this sheet'!H2:H&'From this sheet'!I2:I\'From this sheet'!Q2:Q}; 
 'From this sheet'!R2:R="Finalizado"); 2; 0 )))