| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
import data format
I am using both VLOOKUP and HLOOKUP to move data throughout a spread sheet.
I need to format of the data to move as well as the value. I am pulling several different types of data in to the same cell based on the look up value. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
import data format
hi
going out on a limb here but as i understand it, formulas return values to the cell in which they reside. they cannot return formats. nor perform actions like reform a cell. to reform a cell, you may need a macro. Regards FSt1 "thenight-train" wrote: I am using both VLOOKUP and HLOOKUP to move data throughout a spread sheet. I need to format of the data to move as well as the value. I am pulling several different types of data in to the same cell based on the look up value. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
import data format
Formulas pull data.
They cannot pull formatting of that data. What have you got and what do you want? Gord Dibben MS Excel MVP On Tue, 27 Jan 2009 14:11:01 -0800, thenight-train wrote: I am using both VLOOKUP and HLOOKUP to move data throughout a spread sheet. I need to format of the data to move as well as the value. I am pulling several different types of data in to the same cell based on the look up value. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data From Landscape Format | New Users to Excel | |||
| Import data format, need help | Excel Discussion (Misc queries) | |||
| Import csv data and convert to TIME format | Excel Worksheet Functions | |||
| Import data as number format | Excel Discussion (Misc queries) | |||
| Import data not in correct format | Excel Discussion (Misc queries) | |||
Hybrid Mode
