Vlookup with formatting

[mogro74]

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]

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]

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]

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.