I have a workbook with approx. 20,000 records with 25-30 columns of data. I
utilize vertical lookup tables. The system is way too slow for me. I have a
pretty fast processor in an IBM thinkpad with 1 gig of physical memory.
Surely there is some fix....

use a real database program

"jrrbama" wrote:

I have a workbook with approx. 20,000 records with 25-30 columns of data. I
utilize vertical lookup tables. The system is way too slow for me. I have a
pretty fast processor in an IBM thinkpad with 1 gig of physical memory.
Surely there is some fix....

Maybe you can use one "lookup" and lots of =index().

If you're always matching on column A, you can insert one column (say column Z)
that returns the matching row:

=match(a2,sheet2!a:a,0)

Then instead of =vlookup()'s you can use:

=if(iserror(z2),"",index(sheet2!b:b,z2))

Change the B:B to the column you want to return.




jrrbama wrote:

I have a workbook with approx. 20,000 records with 25-30 columns of data. I
utilize vertical lookup tables. The system is way too slow for me. I have a
pretty fast processor in an IBM thinkpad with 1 gig of physical memory.
Surely there is some fix....

--

Dave Peterson