Excel has a hard time getting data from a LARGE EXTERNAL file. Try putting
the data in the same file.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DTTODGG" wrote in message
...
Hello,

I have a reference file with 3 columns that has 50702 rows:
Zipcode (text) DMARank (Numeric) DMACode (Numeric)
01105 109 543
99950 207 747

I have other files with address data (including zipcodes):
Name Address City State Zip DMACode
Bob 123 North Springfield MA 01105 109
I would like to add the DMARank to the last column in this file, but I get
an error:
"Excel cannot complete this task with available resources. Choose less
data
or close other applications."
I don't believe the error is correct, I can close almost everything and it
still gives me the error. I can run it on another computer and still get
the
error.

Could it be the zipcodes are "text" because some of them begin with
"01105"
and cannot therefore be numeric? Should I convert to numeric, drop the
leading zero in both files, then add it back later?

Is this too much for excel? Should the DMA file be a database or
something?
Do I need to divide the file into smaller pieces? Would Match/Index work
better?

Please help me find a workable solution, we use these DMACodes with many
files and I need to find a way to make it work.

Thank you so much!