lookup function, returning the same format.

  • Thread starter lookup function, returning the same form
  • Start date
L

lookup function, returning the same form

Hello, Im using the Vlookup function and Im trying to find out how i can
transfer the same format from my datasheet to my working sheet. In my
datasheet I have cells in Bold and Italic others with subscripts in
different font colors, when using the Vlookup function I want these data to
be transfered to my working sheet in the same format. Is there a way to do
this using a formula? coz Im not comfortable using macro.

Thanks,
 
D

Dave Peterson

Formulas won't return this kind of formatting.
Hello, Im using the Vlookup function and Im trying to find out how i can
transfer the same format from my datasheet to my working sheet. In my
datasheet I have cells in Bold and Italic others with subscripts in
different font colors, when using the Vlookup function I want these data to
be transfered to my working sheet in the same format. Is there a way to do
this using a formula? coz Im not comfortable using macro.

Thanks,
Click to expand...
 
Top