Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Alternative to IF | Excel Worksheet Functions | |||
Alternative add-on application to VLOOKUPS command? | Excel Discussion (Misc queries) | |||
If alternative | Excel Worksheet Functions | |||
vlookups | Excel Discussion (Misc queries) |