Hi Team,
Need favour about excel VBA for Vlookup function, Since its huge data size, its taking so much of time. So i am looking for excel VBA queries for run vlookup formula. I have 2 excel work books in the data size of around 300000 rows for both files, i am lookuping data from one excel to another excel using vlookup formula, while run the formula its taking more then hour, then paste as values will take again on hour. So need your help to fix this, thanks in advance.
Lookup_value = [Book1.xlsx]Sheet1!A2
Table_array = [Book2.xlsx]Sheet1!$A$2:$B$16
Col_index = 2
Range_lookup = FALSE
After execute this formula, i paste the values from formulas.
Thanks,
Guna
Need favour about excel VBA for Vlookup function, Since its huge data size, its taking so much of time. So i am looking for excel VBA queries for run vlookup formula. I have 2 excel work books in the data size of around 300000 rows for both files, i am lookuping data from one excel to another excel using vlookup formula, while run the formula its taking more then hour, then paste as values will take again on hour. So need your help to fix this, thanks in advance.
Lookup_value = [Book1.xlsx]Sheet1!A2
Table_array = [Book2.xlsx]Sheet1!$A$2:$B$16
Col_index = 2
Range_lookup = FALSE
After execute this formula, i paste the values from formulas.
Thanks,
Guna