Fri 18 Jul 2008, 16:15Delegate Steven said...
Steven has attended:
Excel VBA Intro Intermediate course
VLOOKUP
How could a VLOOKUP for a very large table that would take up a lot of memory be automated to loop row by row?
Or is there another method of doing this?
Mon 21 Jul 2008, 16:06Trainer Roy said...
RE: VLOOKUP
Assuming you're using Excel 2003 or earlier, then a worksheet only has 64K rows, and the VLOOKUP function is effectively instantaneous.
Interpreted VBA code is going to be significantly slower. A quick experiment with a For loop takes about 1 second to get the last-but-one record. So I can't see why you'd want to do this in code, rather than by formula.
/Roy
