Spreadsheet Im working on: https://docs.google.com/spreadsheets/d/1rTzdmKVMqD8sz1D639y5qgvXNBcWaAuBaQOAmwJXdA4/edit#gid=0
I need a formula that returns the Comment
for the Domain
that equals the search key:
with the most recent Timestamp
when Timestamp
is unsorted.
You can see in my example I have tried using both INDEX
and VLOOKUP
but with no success.
Actual spreadsheet has over 5000 rows and multiple sheets, and is quite complex, therefore a QUERY
statement is too inefficient and causes the sheet to crash.