Combine VLOOKUP with filter
<p>I'm doing a weight loss challenge with ~30 friends and am wanting to make a sheet to track where everyone is at. I've set up a simple two question survey for people to answer. The output of the survey for each weigh in is in 3 columns in a spreadsheet:</p>

<p>A                       B.            C
Timestamp.     Name.    Weight</p>

<p>What I am trying to do is find the latest timestamp for each name and then pull in the value from column C that is put in from that timestamp. This would be pulled into a separate sheet in the book with 2 columns - name and latest weight.</p>

<p>I've got it running in Google Sheets. I've searched and tried every formula I've seen listed for a somewhat similar use case but can't find one that works.</p>