Formula to pick-up most recent date against Reference Code

Hi all,

I'm hoping you can help me with an issue I've come across. I'm currently creating a document index, the objective of which is to trace how documents have been updated over time, specifically the costs detailed in each document (see Index Database tab in the attached document). Each document has a specific reference code that helps identify it.

I have also created a Summary tab, which is meant to show the data for each latest update in the Index Database.

What I'm hoping you can help me with is a formula that can be added to the "Last Updated" column (B), which picks up the most recent date in the Index Database against the corresponding Reference number in column C. Any ideas?

I hope that's clear, but happy to elaborate further should there be any confusion or questions.

As always, many thanks in advance for all your help and I look forward to hearing from you!

Kind regards,
G.

You can use this array* formula in cell B3 of the Summary sheet, which should be formatted as a Date in the style you prefer:

=MAX(IF(Table1[Ref]=C3,Table1[Document Date]))

*Note that an array formula needs to be confirmed using the key combination Ctrl-Shift-Enter (CSE), rather than the usual Enter.

The formula should copy itself down automatically.

Hope this helps.

Pete

Thank you @sweep, @Pete_UK, and @Richard Buttrey! That did the trick =)

Regards,
G.