Thread
:
How to lookup a value as displayed
View Single Post
01-24-2023, 06:08 PM
wrdy
Windows XP
Office 2007
Novice
Join Date: Jan 2014
Posts: 28
How to lookup a value as displayed
I have custom formatting "M00000" to display product codes such as: M00123, M20330, M00098
However, when I do VLOOKUP, Excel sees 123, 20330, 98. How do I make Excel lookup the full product code as displayed?
wrdy
View Public Profile
Find all posts by wrdy