hi all , i have data consists of 2.2 million rows , so i had to divide it into 3 different workbooks.
i have another file of 100 thousand entry , i want to vlookup this last file (100 thousand entry) with the 2.2 million rows ( mean do vlookup in the 3 files ) , how can i do this thorugh formula or VBA macro or any other way ?
doing the vloojup in every workbook separately even takes hours to complete , then i have to repeat with other workbooks and...etc, this is looong and complicated way , appreciate your support.
i have another file of 100 thousand entry , i want to vlookup this last file (100 thousand entry) with the 2.2 million rows ( mean do vlookup in the 3 files ) , how can i do this thorugh formula or VBA macro or any other way ?
doing the vloojup in every workbook separately even takes hours to complete , then i have to repeat with other workbooks and...etc, this is looong and complicated way , appreciate your support.
Last edited: