what is the maximum number of vlookups in a given workbook that E.

G

Guest

I have a workbook that has large amounts of vlookups (about 15,000). My
Excel workbook keeps giving me an error message that there are not enough
Excel resources and it cannot save external values.

Is there a limtation on the number of lookups that can be supported in Excel?

Thanks in advance....
 
C

Chip Pearson

There is no limit on lookups per se, but there are limits on
Excel as a whole based on the available memory on the machine.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

I want to save a copy of a wksht. but without any of the formulas 5
Maximum number of worksheets in workbook 1
Use both ISNA and ISERROR in a long formula 2
VLOOKUPS: Limits on # per sheet? 2
DOES EXCEL HAVE a MAXIMUM NUMBER OF COLUMNS PER WORKBOOK? 3
Maximum length of a number 1
Maximum number of worksheets in workbook 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Top