Hi,

My colleague has a file of size 31 MB (56000 rows) in which 2 columns

are of interest (Column B and F)

He also has another smaller file of 7MB which has 10000 rows. In this

file, he has to check whether data in Column Z appears in Column B and

F of bigger file or not. (Its like BigFile!B2&BigFile!F2 can be equal

to SmallFile!Z).

If it exists then we use a IF formula along with ISERROR to say that

"Data exists" or "Data Not Exist". Once we get the results we just do

copy -- paste special -- values so that each time editing of some other

column of the small file excel doesnt hang excel because of

recalculation of lookups.

The formula is working fine and am getting correct results.

But because of the size of the big file, it takes a lot of time to

calculate. I wanted to know as to whether we may load the big data file

in to access and then from excel I perform something like a lookup to

the access database. Is such a thing possible? If yes how. Secondly,

would this method offer significant speed as compared to my earlier

method. Thirdly are there other methods which might speed up this whole

process.

Regards,

HP

India

## Bookmarks