Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
I am having trouble with VLOOKUP. I am getting memory errors. Can I use the
VLOOKUP formula to look up data in an external workbook or does the data have to be in the same workbook? Any help would be great. Thanks, Steph |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
steph44haf wrote:
I am having trouble with VLOOKUP. I am getting memory errors. Can I use the VLOOKUP formula to look up data in an external workbook or does the data have to be in the same workbook? Any help would be great. Thanks, Steph Hi Steph, The data you are looking in with VLOOKUP don't need to be in the same workbook of the formula you are using. Maybe the table you are looking in is too big for your PC memory... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
you can link to external spreadsheets. as for memory it depends on how much data you have.... -- mr_ben ------------------------------------------------------------------------ mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106 View this thread: http://www.excelforum.com/showthread...hreadid=569052 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
Can I have a formula in my lookup value? It isn't working sometimes.
"Franz Verga" wrote: steph44haf wrote: I am having trouble with VLOOKUP. I am getting memory errors. Can I use the VLOOKUP formula to look up data in an external workbook or does the data have to be in the same workbook? Any help would be great. Thanks, Steph Hi Steph, The data you are looking in with VLOOKUP don't need to be in the same workbook of the formula you are using. Maybe the table you are looking in is too big for your PC memory... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
steph44haf wrote:
Can I have a formula in my lookup value? It isn't working sometimes. Try to describe your situation and to post the formula that is not working... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
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 |