lookup function, returning the same format.
Hello, Im using the Vlookup function and Im trying to find out how i can
transfer the same format from my datasheet to my working sheet. In my datasheet I have cells in Bold and Italic others with subscripts in different font colors, when using the Vlookup function I want these data to be transfered to my working sheet in the same format. Is there a way to do this using a formula? coz Im not comfortable using macro. Thanks, |
lookup function, returning the same format.
Formulas won't return this kind of formatting.
lookup function, returning the same form wrote: Hello, Im using the Vlookup function and Im trying to find out how i can transfer the same format from my datasheet to my working sheet. In my datasheet I have cells in Bold and Italic others with subscripts in different font colors, when using the Vlookup function I want these data to be transfered to my working sheet in the same format. Is there a way to do this using a formula? coz Im not comfortable using macro. Thanks, -- Dave Peterson |
All times are GMT +1. The time now is 04:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com