<div>
Thanks for the help. &nbsp;That was it.
</div>


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


<div>
<div class="content wysiwyg-content">
Why would this return a #VALUE error? &nbsp;If formula is in Sheet2, column B5, using the first 9 chars of the value of A5 and we are look for a match of those 9 chars in Sheet1 column A, and wanting to return whatever is in column B of that find. &nbsp;Any suggestions on how the formula needs to chg?<br />
<br />
=VLOOKUP(LEFT(A5-9),Sheet1<wbr />!A:A,1,FAL<wbr />SE)
</div>
</div>


Why would this return a #VALUE error?  If formula is in Sheet2, column B5, using the first 9 chars of the value of A5 and we are look for a match of those 9 chars in Sheet1 column A, and wanting to return whatever is in column B of that find.  Any suggestions on how the formula needs to chg?

=VLOOKUP(LEFT(A5-9),Sheet1!A:A,1,FALSE)

Formula Error 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.