Text Format Lost in vlookup - Help!!!
Text Format Lost in vlookup - Help!!!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Text Format Lost in vlookup - Help!!!

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Midwest, USA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No, Vlookup will not return formats.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com