Table look up most receent

I have two tables.

Table A has two columns: project and status

Table B has 3 columns: date, project, notes

I would like to add a 3rd column in Table A that displays the latest note (and only the latest) from Table B for each individual project.

I can’t seem to find the right formula to do so.

Thanks in advance.

Here you go :slight_smile:


Thanks. That did it!

1 Like