98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VLOOKUP
VLOOKUP
Resolved · Low Priority · Version 2003
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change Excel's default fontYou can change the default font and font size for all spreadsheets created in Excel by: |
