How to lookup a value as displayed

wrdy · #1 01-24-2023, 06:08 PM

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 · #2 01-24-2023, 06:17 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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