|
|
#1
01-24-2023, 06:08 PM
|
|||
|
|||
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? 
|
| 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 |
Windows XP 
Office 2007
Threaded Mode