Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathy - Lovullo
 
Posts: n/a
Default VLOOKUP - 2 Questions

I have 2 questions in regards to VLOOKUP.

1 - Is it possible to retrain the format of the cell which you are pulling
the value of? For example text color

2 - In some of the original cells, the Alt+Enter key was used to perform a
cariage return within a cell. When VLOOKUP returns these cells, the cariage
return shows as a block-type wingding. Is there a way to turn this back into
a carriage return either through the function or using code?

Thanks!
Kathy
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default VLOOKUP - 2 Questions

1. No

2. If you format the cell with the vlookup formula under
formatcellsalignment and check wrap text it will be multiple lines
whenever there is a carriage return, if you want to remove it or replace it
with a space

=SUBSTITUTE(VLOOKUP(A1,D3:E4,2,0),CHAR(10)," ")

will replace the carriage return with a space


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Kathy - Lovullo" wrote in message
...
I have 2 questions in regards to VLOOKUP.

1 - Is it possible to retrain the format of the cell which you are pulling
the value of? For example text color

2 - In some of the original cells, the Alt+Enter key was used to perform a
cariage return within a cell. When VLOOKUP returns these cells, the
cariage
return shows as a block-type wingding. Is there a way to turn this back
into
a carriage return either through the function or using code?

Thanks!
Kathy



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP Problem Ian Excel Discussion (Misc queries) 3 April 6th 06 06:47 PM
VLOOKUP Questions nyys Excel Worksheet Functions 4 January 5th 06 03:41 PM
vlookup and calculation questions dtmd Excel Worksheet Functions 2 November 19th 05 11:34 PM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 01:09 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"