I used 600K rows as an example of what I thought excel could handle using the
Vlookup function. My current situation is only dealing with 23K rows of data.
I will check out this link you supplied, thanks.

"Jim Thomlinson" wrote:

Check out this link on memory and calculations...

http://www.decisionmodels.com/index.htm

If you really mean 600k rows then you are defintly in trouble here. If you
meant 60k rows from an external spreadsheet then you are still in a bit of
hot water but you might be able to tweak things to make them work.

As opposed to a vlookup which has pile of overhead you could look at using
an external database query to the sheets involved (a much smaller footprint).

--
HTH...

Jim Thomlinson


"Kim" wrote:

I have two vlookup functions in one spreadsheet linking data from two other
spreadsheets. I have 23K rows and I received an error of "Excel cannot
complete this task with available resources. Choose less data or close other
applications." My IT department is saying that I should query data in a table
(access) rather than storing data of 20K + rows using the Vlookup in excel.
Shouldn't excel be able to handle 600K rows of data using the Vlookup
function?