• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help on creating VBA VLOOKUP Array for over 1 Million Rows

E

ExcelKP

New Member
Need Help on creating VBA VLOOKUP Array for over 1 Million Rows. Please find attached excel file with 15000 rows . Normal Vlookup VBA is taking long time (May be more than a day. Please help if possible.
 

Attachments

Last edited:
Your explanation of what you want is not clear. You have not shown us what you have attempted. Cannot determine what your result range represents. Help us to help you with a better explanation of your objective. We are not mind readers here.
 
ExcelKP
Why do You would like to use VLOOKUP?
Could You use something like this?
Long time ... if a lot of rows to solve then it would take a lot of time too.
Added new version:
If You'll still use only Vlookup then You could test this sample ...
Without answers - there are challenges to give more specific guesses.
 

Attachments

Last edited:
vletm said:
ExcelKP
Why do You would like to use VLOOKUP?
Could You use something like this?
Long time ... if a lot of rows to solve then it would take a lot of time too.
Added new version:
If You'll still use only Vlookup then You could test this sample ...
Without answers - there are challenges to give more specific guesses.
Click to expand...
@vletm : Sorry to say it is not helping as it is taking hours to execute the task. If possible, please help in using array.
 
ExcelKP
I see - that's why it took so long time (days) to write something feedback.
... now, these takes any hours - instead of days.
Without realistic sample file there are challenges to verify anything.
 
vletm said:
ExcelKP
I see - that's why it took so long time (days) to write something feedback.
... now, these takes any hours - instead of days.
Without realistic sample file there are challenges to verify anything.
Click to expand...

Sorry for the late reply Sir...Will send you the code I am preparing soon. If possible please help in Array
 
vletm said:
ExcelKP
I see - that's why it took so long time (days) to write something feedback.
... now, these takes any hours - instead of days.
Without realistic sample file there are challenges to verify anything.
Click to expand...

@vletm : Apparently, The second file provided by you is much faster. Thank you for your help.
Please find attached macro file prepared by me. Please help in creating by using array which will be faster, i guess.

I am unable to upload the file with over million here but placed random formulas in J6001 of "Database" sheet and G2 in "Result" sheet. Please use the formulas to increase the base range.

There is delay in my response due to festival season in India. My apology again for delay in my response.
 

Attachments

ExcelKP
Is that something like ... a realistic file?
Is it true that there are fixed data in three columns - nothing else?
Use to increase ... normally, I'll skip all formulas at once.
Your offer of data could give a lot of duplications ... means almost all could have same values.
... then why to try to get values someway from sheet to sheet?
That's why, I've asked a realistic sample file.
You're guessing something ... why?
What is connection with taking hours... days and some festival season?
You should open Your thread and You should have time to be active.
Ps. My 2nd file is basically same as my 1st file with my normally used options, which shows that it's working - a sample.
 
You must log in or register to reply here.
Back
Top