Vlookup with formatting

mogro74

New Member
Joined
Aug 18, 2008
Messages
2
Hi. I am using vlookup and I need to have the same formating as the original sheet, example "How are you, Susan. How can i dothis.

Thank you in advance.
 

iliace

Well-known Member
Joined
Jan 15, 2008
Messages
3,541
You'll need macro to do this, VLOOKUP looks strictly at values. In fact, there are no built-in functions that look at font formatting.
 

mogro74

New Member
Joined
Aug 18, 2008
Messages
2
Thanks for your help. I don't do macros.
Another question: I want cell a1 to = cell b1, b1 has text in italic, how do I get a1 to show text in italics? (using excel 97).
Thanks
 

iliace

Well-known Member
Joined
Jan 15, 2008
Messages
3,541
Automatically? You can't - you would need a macro. You can use format painter, though that's probably not very helpful.

Also look into defining a style; you can change just one format definition (the style), and all cells formatted with that style will inherit the new format. Just like Word, in fact.
 

Forum statistics

Threads
1,085,693
Messages
5,385,214
Members
401,936
Latest member
stephenpoff

Some videos you may like

This Week's Hot Topics

Top