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