E
erikhs
Hi,
Say you have a database of 20 000 or so entries, and you wish to looku
1000-3000 values in this database. Would it be faster than the workshee
function VLOOKUP, if you loaded the parts of the database you neede
into an array and then used a loop to get the values. something like:
For i = 1 to lastlookupvalue
Lookup(i) = Application.Vlookup(lookupvalue(i), array, x, 0),
Next i
and pasting it back to the worksheet. Do you have experience of whic
is faster if run from VBA, and the database is separate from th
lookup-values
Say you have a database of 20 000 or so entries, and you wish to looku
1000-3000 values in this database. Would it be faster than the workshee
function VLOOKUP, if you loaded the parts of the database you neede
into an array and then used a loop to get the values. something like:
For i = 1 to lastlookupvalue
Lookup(i) = Application.Vlookup(lookupvalue(i), array, x, 0),
Next i
and pasting it back to the worksheet. Do you have experience of whic
is faster if run from VBA, and the database is separate from th
lookup-values