ExcelBanter - Retaining Formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Retaining Formats (https://www.excelbanter.com/excel-programming/287410-retaining-formats.html)

Mike[_40_]

Retaining Formats

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

Dave Peterson[_3_]

Retaining Formats

formulas return values only.

Mike wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 12:15 PM.