Compare two Table(Any efficient way)

DONE1

I wrote a code as follows to compare 2 tables on diff worksheet.
Each work sheet has about 6000 Rows.
The code works but appears to Work very slow.
Is there a more efficient way to do it.

TABLE1

TABLE2
EXPECTED RESULT IN
TABLE1

Nov 7 '06 #1

Killer42

I wrote a code as follows to compare 2 tables on diff worksheet.
Each work sheet has about 6000 Rows.
The code works but appears to Work very slow.
Is there a more efficient way to do it.
...

You might be better off using one of Excel's built-in lookup functions to populate the Tag column. For example, I recreated your two tables from the data shown in your post, but in TABLE2 I reversed the order of the two columns. Then I used this formula in cell C2 of TABLE1, I placed this formula =VLOOKUP(B2,TABLE2!$A$2:$B$5,2,FALSE). I copied this cell and pasted it down the rest of the column, and this is the result... (edited slightly for formatting here)

Nov 9 '06 #2

DONE1

Thank you so much

Nov 15 '06 #3

Killer42

Thank you so much

No problem. Let us know whether it works.

Nov 15 '06 #4