20,000 records, 30 columns, look-up formula's I need speed!!!!!

J

jrrbama

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....
 
D

Dave Peterson

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.
 
Top