| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retaining conditonal formats | Excel Worksheet Functions | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| retaining formats when referring to cells | Excel Discussion (Misc queries) | |||
| retaining formulas | Excel Worksheet Functions | |||
| Retaining formats | Excel Discussion (Misc queries) | |||
![Mike[_40_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
