How to compare data between two tables

Closed
Stace - Jul 14, 2009 at 05:18 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 16, 2009 at 11:37 PM
Hello,

I have two tables (table A and table B) and I need to compare the two tables to see if a specific userid exist in both tables. If the id exist in both tables then I want to paste the information from A into another table.

2 replies

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 16, 2009 at 11:37 PM
use =countif(RangeSecondTable, "=" & useridFirstTable) if greater than 0 then it means the userid exists
so put a IF statement to above to copy your data
1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 16, 2009 at 11:37 PM
use =countif(RangeSecondTable,"=" & useridFirstTable) if greater than 0 then it means the userid exists
so put a IF statement to above to copy your data
0