I have a table and am using =VLOOKUP(B3,Table2,2,FALSE) to automatically fill in descriptions for products. Only thing is, I have bolded and underlined text in the description and when VLOOKUP locates the information it appears as regular text. Help...
You cannot bring across cell formatting with Excel formulas. You would have to switch over to a VBA-based lookup process that copied the entire cell contents and attributes.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hello Sinnes.
When a vlookup is searching it is trying to match the values only , not the format.
If you wanted the result of the vlookup to be formatted the same way as the source then you will have to select the area and change the format manually, you can do this prior to writing the formula or after.
Regards
Peter
Thanks everyone, I didn't receive email notification that anybody had replied so I started a new thread, whoops
I have attached an example of what I'm trying to do, spent almost 2 hours playing around with it this morning and am pretty much feeling defeated.
Any help would be great
Is there a way to keep the formatting, IE Bolded and Underlined text?
=VLOOKUP(B29,Table2,2,FALSE)
Any help would be great
Not using VLOOKUP I'm afraid or any other standard Excel function for that matter.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Anything else you may be able to suggest, other than VLOOKIP? I have a database that pulls a product description based on the product selected from the dropdown menu. The table containing all the information contains a lot of formatting, and the descriptions are fairly long.
I've attached an example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks