Text Format Lost in vlookup - Help!!!

axisjon · Mar 20th, 2002, 11:23 AM

When I use vlookup and return the correct data, I lose the Boldface format codes from the original data. Is there any way to keep the original format? Thanks!

Al Chara · Mar 20th, 2002, 04:35 PM

No, Vlookup will not return formats.

Damon Ostrander · Mar 20th, 2002, 04:41 PM

Hi Jon,

The simple answer is no. Functions can only return data, and cannot format cells in any way. Only macros (and manual editing) can do this. It would be possible to write a macro that would format the text exactly the same way it is formatted in your lookup table.

Mar 20th, 2002, 04:35 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	No, Vlookup will not return formats. __________________ Kind regards, Al Chara

Mar 20th, 2002, 04:41 PM	#3
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Jon, The simple answer is no. Functions can only return data, and cannot format cells in any way. Only macros (and manual editing) can do this. It would be possible to write a macro that would format the text exactly the same way it is formatted in your lookup table. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

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

Mar 20th, 2002, 11:23 AM	#1
axisjon New Member Join Date: Mar 2002 Location: Midwest, USA Posts: 9	When I use vlookup and return the correct data, I lose the Boldface format codes from the original data. Is there any way to keep the original format? Thanks!