View Single Post
 
Old 01-24-2023, 06:08 PM
wrdy wrdy is offline Windows XP Office 2007
Novice
 
Join Date: Jan 2014
Posts: 28
wrdy is on a distinguished road
Default 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?
Reply With Quote