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


<div>
<div class="content wysiwyg-content">
Ive set up a lookup table for assets but a discrepancy with asset numbering format is creating problems.<br />
The lookup table has data in which the asset number has a letter followed by 3 digits. &nbsp;eg A001<br />
But the lookup value is A1. &nbsp;I want to be able to recognise A001 as the same asset number.<br />
How do I do this?<br />
Is it best to convert one set of the asset numbers into the same format as the other?<br />
If so, how do I do this? say A001 to A1
</div>
</div>


Ive set up a lookup table for assets but a discrepancy with asset numbering format is creating problems.
The lookup table has data in which the asset number has a letter followed by 3 digits.  eg A001
But the lookup value is A1.  I want to be able to recognise A001 as the same asset number.
How do I do this?
Is it best to convert one set of the asset numbers into the same format as the other?
If so, how do I do this? say A001 to A1

Excel - 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.