Forum Discussion
Problem with LOOKUP function.
I have a workbook which keeps track of money in an account. I use the LOOKUP function to lookup the most recent date in one column and return the corresponding value in another column thereby telling...
Your formula tries to find the numeric representation of the max date in column C. Instead, find the location of the max date in column A, then return the corresponding value in column C:
=XLOOKUP(MAX(A2:A50), A2:A50, C2:C50)
or
=VLOOKUP(MAX(A2:A50), A2:C50, 3, FALSE)