Retaining Formats from VLOOKUP

  • Thread starter Thread starter Squid
  • Start date Start date
S

Squid

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 can return values--not formatting.

Any chance you can use Format|conditional formatting to duplicate the
formatting?

(Use the same rules in both spots.)
 
Back
Top