How to compare data between two tables

Closed
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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