Re: Vlookup problem
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Thu, 24 Apr 2008 08:47:39 -0500
Maybe you could open the data.xls before you open the enquiry.xls workbook. If
the "sending" workbook is open, I bet it'll be less intense for excel.
And (just a silly guess), if you're bringing back the 13th column with the
=vlookup() formula, maybe(???) using =index(match()) would be less stressful.
And without seeing your formula, maybe you're using the whole column as the
lookup table. Maybe limiting the range would be better, too.
yclhk wrote:
I have two linked excel files, enquiry.xls and data.xls
The enquiry.xls is with the vlookup formula to lookup the data in data.xls.
It works OK, however, when the data in data.xls upto row 5346, the lookup in
enquriy.xls returns with the error message stating that the memory is not
enough. There are 13 column (i.e. col A to M) in data.xls, and my PC is
running Windows XP SP2, Office 2000 (Chinese) and with 1GB ram on board.
What is the problem caused the error and how to correct it ?
Thanks,
--
Dave Peterson
.
- Follow-Ups:
- Re: Vlookup problem
- From: yclhk
- Re: Vlookup problem
- References:
- Vlookup problem
- From: yclhk
- Vlookup problem
- Prev by Date: Blank cells
- Next by Date: Re: how do i get more than 3 colours in conditional formatting
- Previous by thread: Vlookup problem
- Next by thread: Re: Vlookup problem
- Index(es):
Relevant Pages
|
