xlookup max date

%3CLINGO-SUB%20id%3D%22lingo-sub-2024180%22%20slang%3D%22en-US%22%3Exlookup%20max%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024180%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20look%20up%20the%20last%20datum%20(date)%20in%20a%20column%20and%20find%20the%20data%20in%20a%20cell%20on%20that%20row%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2024180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2024216%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20max%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024216%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914907%22%20target%3D%22_blank%22%3E%40Peter4902%3C%2FA%3E%26nbsp%3BNot%20entirely%20sure%20what%20you%20have%20in%20mind%2C%20but%20perhaps%20something%20like%20in%20the%20picture%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-31%20at%2011.43.24.png%22%20style%3D%22width%3A%20420px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243555iBE2587DC3B996D84%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-31%20at%2011.43.24.png%22%20alt%3D%22Screenshot%202020-12-31%20at%2011.43.24.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026591%22%20slang%3D%22en-US%22%3ERe%3A%20xlookup%20max%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BSuper!%20That%20will%20do%20the%20job.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.