Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2023, 06:08 PM
wrdy wrdy is offline How to lookup a value as displayed Windows XP How to lookup a value as displayed Office 2007
Novice
How to lookup a value as displayed
 
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
  #2  
Old 01-24-2023, 06:17 PM
wrdy wrdy is offline How to lookup a value as displayed Windows XP How to lookup a value as displayed Office 2007
Novice
How to lookup a value as displayed
 
Join Date: Jan 2014
Posts: 28
wrdy is on a distinguished road
Default

OK, I've found the answer to my own question. I need to use the TEXT function, e.g. TEXT(123,"M00000").
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with lookup / v lookup big failure mda99das Excel 4 11-04-2022 09:38 AM
contents not displayed Rectorth Word 0 02-10-2018 04:06 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell sglandon Excel 6 05-05-2016 09:44 AM
image cannot currently be displayed geddit PowerPoint 1 06-18-2012 09:26 AM
'this image cannot currently be displayed' eNGiNe Word 0 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft