Although running SQL on text files is amazingly fast (considering there are
no indexes) there might be an advantage
to move to a real database like SQLite. Very simple, very fast and very good
free VB(A) wrapper available.
Not sure you were thinking of using SQL, but I think when your lookups are
getting complex using SQL will make
it a lot simpler.

RBS


"Roger on Excel" wrote in message
...
I use vlookup to access data from within my spreadsheet. The extensive
dataset I have is on one of the sheets and is large and cumbersome.

I understand that it is possible to link my sheet to an ancillary text
file
within which i can store my database.

How does one go about doing this and will vlookup work?

Can anyone help or redirect me?

Thanks,

Roger