VLOOKUP Max Find

[Jayliam]

I am trying to find the MAX date and time value in a column using VLOOKUP. Below is the code I have. I know it doesn't work. Can anyone shed some light??

=IF(K18="","",VLOOKUP(MAX(J17,J18:K114,2,FALSE)))

Thank you for your support in advance.

 

[Fluff]

How about
=IF(K18="","",VLOOKUP(MAX(J18:J114),J18:K114,2,FALSE))

 

[Jayliam]

It did not work. I have included a screen shot for your review.

 

[Fluff]

You cannot attach images to the board, but there are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html
that enable you to post data to the board
Are your date/time values in col J?
Also are they actual dates, or text?