Append values from the row with the most recent date

[m3rl1n]

Hello All,

I'm trying to append some values using the Lookup function however it should select the value with the most recent date. Currently it selects the value with the oldest date.

On DM sheet, columns B-G are supposed to be populated from columns C-H on GVM sheet.
Location ID (Column A, DM sheet) has multiple matches on DM sheet column B, so I need to get only the latest one. Hope it makes sense. Please see attached for more details. Please help me fix the formula.

Many thanks

[rylo]

Hi

How about you sort the data on the GVM sheet by date, descending, so that the first appearance will be the most recent one.

rylo