vlookup - available resource problem

G

Guest

I have a lookup table in a separate excel file that has two columns and
32,869 rows.

I get the following message when I try to create a lookup using Vlookup to
this file:

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

I have no other applications running of any significance I get the same
message on another machine.

Does anyone know if there is a limitation of the size of lookup table you
can have. I really want to have five similar lookups.

Thanks
Kim Ward
 

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

Similar Threads

External data range 1
Vlookup Error Message - Excel 2003 8
Vlookup problem 1
Excel can not complete this task with available resources. Choose less data or close other applicati 1
VLOOKUP Under VBA 1
VLookUP Problem with Time Comparision 10
vlookup table in external worksheet 5
Vlookup problem 8

Top