If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup character limitations
is vlookup limited in retrieving cell contents greater than 255 characters? I
have a vlookup function that is properly retrieving the cell, but the text string is truncated at 255. Is there some way to grab the entire cell content or some work around to this? |
#2
|
|||
|
|||
vlookup character limitations
No, =vlookup() isn't limited like that.
But if your sending workbook is closed, excel and windows are limited that way--even with a simple formula that points a cell. If you open the workbook (and recalculate), you'll see the entire string. 808bobby wrote: is vlookup limited in retrieving cell contents greater than 255 characters? I have a vlookup function that is properly retrieving the cell, but the text string is truncated at 255. Is there some way to grab the entire cell content or some work around to this? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|