<div>
You're welcome. Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
lookupRes = Application.WorksheetFunct<wbr />ion.VLooku<wbr />p(&quot;myvalue<wbr />&quot;, Sheets(&quot;Library&quot;).Range(&quot;B<wbr />1:C20&quot;, 2, False)<br />
<br />
This function gets the value 2 cells over from where VLOOKUP finds a match, perfect!<br />
<br />
I need to following to work in order to get the Comment from the matched cell<br />
<br />
fuzzy code:<br />
lookupRecComment = Application.WorksheetFunct<wbr />ion.VLooku<wbr />p(&quot;myvalue<wbr />&quot;, Sheets(&quot;Library&quot;).Range(&quot;B<wbr />1:C20&quot;, 2, False).Comment.Text<br />
<br />
How do I get the row, cell, range or something navigational so I can grab the Comment.Text?
</div>
</div>


lookupRes = Application.WorksheetFunction.VLookup("myvalue", Sheets("Library").Range("B1:C20", 2, False)

This function gets the value 2 cells over from where VLOOKUP finds a match, perfect!

I need to following to work in order to get the Comment from the matched cell

fuzzy code:
lookupRecComment = Application.WorksheetFunction.VLookup("myvalue", Sheets("Library").Range("B1:C20", 2, False).Comment.Text

How do I get the row, cell, range or something navigational so I can grab the Comment.Text?

Excel VLOOKUP &gt; Comment

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

Excel VLOOKUP &gt; Comment

Excel VLOOKUP > Comment