troubleshooting Question

Excel - Vlookup

Avatar of gh_user
gh_userFlag for Australia asked on
Microsoft Excel
3 Comments1 Solution82 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros