Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
I have the following Vlookup function:
=VLOOKUP(F7,'\\********\Public\Lab\Tech Service Lab\Sample Log-in\[Customer Sample Log.xls]2006 Log-In Sheet'!$1:$10000,13,FALSE) It is pulling the correct data, but not all of it. Is there a display maximum and if so how can I change that? The full data does pull in when you have the database excel sheet open along with my current excel report. However, when just the report is open like I said before it is not display all of the contents of the cell. Any help would be most appreciative |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Hi,
This may be a limitation. I think excel has a 255 character limit per cell. You may be able toget more into a cell but sometimes when I copy data I get a warning that I have exceeded the cell limit and data will be truncated. peter "train99tank" wrote: I have the following Vlookup function: =VLOOKUP(F7,'\\********\Public\Lab\Tech Service Lab\Sample Log-in\[Customer Sample Log.xls]2006 Log-In Sheet'!$1:$10000,13,FALSE) It is pulling the correct data, but not all of it. Is there a display maximum and if so how can I change that? The full data does pull in when you have the database excel sheet open along with my current excel report. However, when just the report is open like I said before it is not display all of the contents of the cell. Any help would be most appreciative |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |