Alternative to Vlookups?
 

I have to run about 250,000 vlookups in one of my spreadsheets to mak
sure that the correct data is being copied from the respective sheet.
As you can probably tell, this takes a LONG time, so i was wondering i
there would be a better approach to this problem.

I have 5 sheets total, sheet 2-5 are the ones with data (from dynami
text files being imported at the start of the script) and sheet 1 i
where i have the vlookups that compare a value in cell B, and copie
the data if it matches.

1 More question, does excel have any easy way to have a timing metho
to see how long my macros run (to see if my changes are making m
macros faster or slower).

Thanks
Cor

--
Message posted from http://www.ExcelForum.com

Alternative to Vlookups?
 

you could use a query to retrieve the info you need form the text
files....

then construct the query with the proper joins to retrieve the correct
information in 1 sweep.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Cory Thomas wrote:

I have to run about 250,000 vlookups in one of my spreadsheets to make
sure that the correct data is being copied from the respective sheet.
As you can probably tell, this takes a LONG time, so i was wondering if
there would be a better approach to this problem.

I have 5 sheets total, sheet 2-5 are the ones with data (from dynamic
text files being imported at the start of the script) and sheet 1 is
where i have the vlookups that compare a value in cell B, and copies
the data if it matches.

1 More question, does excel have any easy way to have a timing method
to see how long my macros run (to see if my changes are making my
macros faster or slower).

Thanks
Cory


---
Message posted from http://www.ExcelForum.com/

Alternative to Vlookups?
 

I think a query might take longer.

When i said that i have a key value in column B, i meant that i have
unique key value, so i would have to have about 14,000 queries in orde
to get all my columns, and i would have to query from 3 text files fo
each iteration, unless of course i missed what you were trying to say

--
Message posted from http://www.ExcelForum.com