<div>
This is the formula I tried<br />
=MAX(VLOOKUP(R2,$A$1:$N$57<wbr />,12,FALSE)<wbr />)<br />
<br />
as well as<br />
=VLOOKUP(R2,$A$1:$N$57,MAX<wbr />(L2:L50),F<wbr />ALSE)
</div>


This is the formula I tried
=MAX(VLOOKUP(R2,$A$1:$N$57,12,FALSE))

as well as
=VLOOKUP(R2,$A$1:$N$57,MAX(L2:L50),FALSE)

<div>
Perfect!!<br />
Thank you both for the answer<br />
I do appreciate your time.<br />
Have a great day!! &nbsp;:)
</div>


Perfect!!
Thank you both for the answer
I do appreciate your time.
Have a great day!!  :)

<div>
<div class="content wysiwyg-content">
need assistance with a vlookup formula to return the greater date in a table for a specific product that may have 5 dates listed in the table. &nbsp;Please help.
</div>
</div>


need assistance with a vlookup formula to return the greater date in a table for a specific product that may have 5 dates listed in the table.  Please help.

vlookup return greater date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.