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.
Appreciate your help very much!
1 Answers
try:
=INDEX(IFNA(VLOOKUP(B5:B&C5:C&D5:D;
SORT({'From this sheet'!G2:G&'From this sheet'!H2:H&'From this sheet'!I2:I\'From this sheet'!Q2:Q};
ROW('From this sheet'!Q2:Q); 0); 2; 0 )))
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 )))
Related