xlookup max date

Copper Contributor

How can I look up the last datum (date) in a column and find the data in a cell on that row?

2 Replies

@Peter4902 Not entirely sure what you have in mind, but perhaps something like in the picture below.

Screenshot 2020-12-31 at 11.43.24.png

@Riny_van_Eekelen Super! That will do the job.