Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question.
Hello again.
I am using Vlookup to return from a table than contains large sections of text, however, what is returned in the cells is only a portion of the text in the cell being search, not the whole paragraph. Is there anyway to get Vlookup to return all the text that is in that cell? Thanks. -Alan Lueke |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question.
destination cell larger or format to wrap text
-- Don Guillett SalesAid Software "AJL" wrote in message ... Hello again. I am using Vlookup to return from a table than contains large sections of text, however, what is returned in the cells is only a portion of the text in the cell being search, not the whole paragraph. Is there anyway to get Vlookup to return all the text that is in that cell? Thanks. -Alan Lueke |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question.
Alan
How large is "large"? Do you see all the text in the formula bar, but not in the cell? You can enter 32767 characters in a cell, but Excel will display or print only 1024 of these characters in the cell. If this is the case, paste specialvalues in your lookup cell then stick in an ALT + ENTER every 100 characters. Someone else may have another(better) workaround so hang in. Gord Dibben MS Excel MVP On Mon, 16 Oct 2006 09:21:02 -0700, AJL wrote: Hello again. I am using Vlookup to return from a table than contains large sections of text, however, what is returned in the cells is only a portion of the text in the cell being search, not the whole paragraph. Is there anyway to get Vlookup to return all the text that is in that cell? Thanks. -Alan Lueke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP question | Excel Worksheet Functions | |||
Vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP question | Excel Worksheet Functions | |||
vlookup question | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |