Maintain multi-line format when fetching with VLOOKUP

[estillbham]

I have created a VLOOKUP to retrieve an address from a worksheet (Source). In the Source Worksheet, the address was entered with a return (Alt-Enter) at the end of each line. The address can be 3 to 10 lines long.


If I copy this cell from Source to Target Worksheet, the formatting comes along with the address. If I use VLOOKUP, the address is one long line with a boxed question mark instead of the return.

 

[dan_l]

Ya know, I'm not sure. This one is right up Chandoo's alley, I think.


My initial inkling would be to try to bust it up and reassemble it with concatenated vlookups with line breaks built in.


http://cache.gawker.com/assets/images/gawker/2010/01/wonka032.jpg

 

[estillbham]

Thanks, Dan_l. I will give that a try. "The longest way round is the shortest way home," as C.S. Lewis said.


Happy Holidays to you.