| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup formats
Hello. I am trying to have excel lookup values as well as cell formats. My
lookup works but no formating of the cells is bought in with the data. Cannot find this anywhere. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup formats
VLOOKUP is a function designed to return only values.
I can't think of a way to do this outside of getting a macro to copy the cell's format and than have it paste special the format back over. HTH. "CJRolls" wrote: Hello. I am trying to have excel lookup values as well as cell formats. My lookup works but no formating of the cells is bought in with the data. Cannot find this anywhere. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
