Hi,
I need to compare the rows of two worksheets Columns from A to V
The original has about 20,000 rows and columns from A to V
The sheet which has to be compared with the original has about 16,000 rows and columns from A to V
The Solution
I inserted an extra 1st column in both the sheets and used this formula
=B2&C2&D2&E2&F2&G2&H2&I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2&V2&W2&X2
In the sheet (16,000 rows) which has to compared I put TRUE in the last column
Then I used this formula in the last Column of the Original sheet (20,000 rows)
=VLOOKUP(A2,'0riginal'!A:Y,25,FALSE)
The Problem
This worked but due to the large information the VLOOKUP function is running slow and the file Hangs, the size has increased to 20MB+
Is there a different approach to the solution?