| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to vlookup and keep format?
Hi, I'm looking for a way to do vlookup, and I want to keep the format in argument 3 (where argument 3 in "=vlookup(A2,MyLookup,2,0)" is "2") -- farful ------------------------------------------------------------------------ farful's Profile: http://www.excelforum.com/member.php...o&userid=36172 View this thread: http://www.excelforum.com/showthread...hreadid=561591 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way to vlookup and keep format?
Nope... VLookup is a function and functions can ONLY return values. They can
not modify formats or other settings. This is just as true of built in functions as it is of user defined functions... -- HTH... Jim Thomlinson "farful" wrote: Hi, I'm looking for a way to do vlookup, and I want to keep the format in argument 3 (where argument 3 in "=vlookup(A2,MyLookup,2,0)" is "2") -- farful ------------------------------------------------------------------------ farful's Profile: http://www.excelforum.com/member.php...o&userid=36172 View this thread: http://www.excelforum.com/showthread...hreadid=561591 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way to vlookup and keep format?
Hmm, in that case, anyone have a VBA code or such that would vlookup an keep format -- farfu ----------------------------------------------------------------------- farful's Profile: http://www.excelforum.com/member.php...fo&userid=3617 View this thread: http://www.excelforum.com/showthread.php?threadid=56159 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way to vlookup and keep format?
Not using a formula - you'd have to use VBA to search for the match and copy/paste the return value
Tim "farful" wrote in message ... Hmm, in that case, anyone have a VBA code or such that would vlookup and keep format? -- farful ------------------------------------------------------------------------ farful's Profile: http://www.excelforum.com/member.php...o&userid=36172 View this thread: http://www.excelforum.com/showthread...hreadid=561591 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP format issues? | Excel Worksheet Functions | |||
| Vlookup,format general, format text | New Users to Excel | |||
| vlookup format problem | Excel Worksheet Functions | |||
| Vlookup based on Format | Excel Discussion (Misc queries) | |||
| Format into VLookup | Excel Worksheet Functions | |||
![farful[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
