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