Thread: [Solved] Keeping the source format when extracting data from multiple cells using Vlookup function
View Single Post
 
Old 11-11-2016, 10:36 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You can't return character formats via formulae - they return data only. Besides which, you're applying a different format anyway (bold, blue).

What you could do is put the superscript notes into a separate column on the 'Data Input Sheet' and have a separate lookup for that (also in another column) on the 'Data Output Sheet'. By merging & centring the other rows and right-aligning the language and left-aligning the superscripted notes, you can approximate the layout you're after.

See attached demo.
Attached Files
File Type: xlsm Copy of Test sheet.xlsm (57.4 KB, 26 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote