LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Returning Formatting on a Lookup

I have a named range with values containing special formatting (i.e.,
underlined initial letters, bolding, etc) that I would like to have returned
to another range based on a lookup(key) value. The lookup is successful
(using VLOOKUP) however, the special formatting is not returned. Both field
are text fields. Is there some way to perform a lookup and have the
formatting returned as well as the value?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup returning #n/a irvine79 Excel Discussion (Misc queries) 2 June 1st 09 11:11 PM
Lookup returning incorrect value Sherry Excel Discussion (Misc queries) 3 January 29th 08 07:57 PM
Lookup is not returning the right value. vvenk Excel Worksheet Functions 3 December 3rd 07 09:26 PM
lookup returning several cells Andre Excel Discussion (Misc queries) 4 July 13th 06 10:56 PM
Returning all values from a lookup - not just the first/last one Jim Burns Excel Worksheet Functions 2 June 20th 05 04:04 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"