VBA VLookup() Vs Find()

[John1985]

Hi to all,

I have to do alot of vlookup type searches in my program and I was wondering which one of the 2 options in the title would be quicker and more efficient since there will be around 500 of these searches.

So...
VLookUp(what,range) or Range().Find().Offset().Value ?

Thanks

 

[Colin Legg]

Hi,

In terms of efficiency the VLookup() call will be the faster of those two options if the lookup values are valid and will be found. If a lot of the lookup values won't be found then error overhead from the VLookUp calls will even things out.

HTH,

 

[John1985]

all will have exact values found since i put the exactvalue=true in all comboboxes. Therefore, I will lean towards the vlookup. Thanks!