Loop a Vlookup

[AndyD]

Hi
i use the following type index in a spreadsheet and copy it down several thousand cells

=index(range_1,match(A2,range_2,0),2))

would it be more efficient if i did something like this in VBA? (if so, if someone could supply code would be great...

eg something along lines of

Cells(i,1)=vlookup formula (using "false", so always finds a match)
next i

etc, etc

any solutions (or ideas) welcomed...
cheers all
Andy

 

[PaddyD]

"would it be more efficient if i did something like this in VBA? "

unlikely - built in functions invariably exute faster than anything you have to compile, among other reasons.

what, exactly, are you trying to do & what problems are you trying to overcome..

 

[BrianB]

[built in functions invariably exute faster ]

I agree, but with a macro we can put something in the statusbar to show progress (eg. row number) when a long re-calc is required - which does show that Excel has not crashed. This is almost as good as the Cup of Coffee method (grin).