<div>
Try <br />
<br />
=IFERROR(VLOOKUP(max(Regis<wbr />tration_Ta<wbr />ble!A:a),R<wbr />egistratio<wbr />n_Table!A:<wbr />I,3,0),&quot;&quot;)<wbr />
</div>


Try

=IFERROR(VLOOKUP(max(Registration_Table!A:a),Registration_Table!A:I,3,0),"")

Developer

Murray Brown

<div>
<div class="content wysiwyg-content">
Hi. I am using the following Excel formula to find a date using a serial number<br />
in column K. The Registration_Table data will have more than one date against that<br />
serial number. I want tofind the most recent date. How do I do this?<br />
<br />
<br />
=IFERROR(VLOOKUP(K2,Regist<wbr />ration_Tab<wbr />le!A:I,3,0<wbr />),&quot;&quot;)
</div>
</div>


Hi. I am using the following Excel formula to find a date using a serial number
in column K. The Registration_Table data will have more than one date against that
serial number. I want tofind the most recent date. How do I do this?


=IFERROR(VLOOKUP(K2,Registration_Table!A:I,3,0),"")

Excel Find the mosr recent date using vlookup

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.