Retaining Formats

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a Vlookup formula in worksheet1 that looks up
values from worksheet2. These values in worksheet2 can
either be percentages or currency amounts.

Is it possible to have vlookup (or via code) to have
return value from the lookup to retain the format from
worksheet2?

Thanks
Mike
 
formulas return values only.
I have a Vlookup formula in worksheet1 that looks up
values from worksheet2. These values in worksheet2 can
either be percentages or currency amounts.

Is it possible to have vlookup (or via code) to have
return value from the lookup to retain the format from
worksheet2?

Thanks
Mike
Click to expand...
 
Back
Top