External data range


FP Novice

I posted this question yesterday and cannot find the post anywhere so I
apologize if someone answered this already.

I am using VLOOKUP to an external workbook that has 14,841 rows of data. The
lookup worked great when I only had 13,978 rows of data, now that I have
added more rows I get a memory error that says:

Excel cannot complete this task with available resources. Choose less data
or close other applications.

So, my question is two fold. First what is the limitation of Excel lookup
since I have many more rows of data that I will ultimately want to lookup.
Second, what better solution can I use other than VLOOKUP if the size of the
data is an issue?


FP Novice

I am going to answer my own question on this one...

I changed the lookup from an external workbook to a worksheet in the
workbook doing the VLOOKUP, this seems to have cleared the memory error.

I would still like to know of any limitations that there may be.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question