Compare two excel Columns of differant size

thanks a lot venkat ..it was sucessful..but I wanted to know that what happens if I compare a column with 4 lakh mobile numbers to column with 1 lakh numbers..will this work..

For access you will not need VBA. Create two tables with two columns in each table. The first field/column of the table will be for the number and the second for the status. Import the column A in one table and Column B in the other table. Now run the update sql to update the status

lets say table you have these two tables

CREATE TABLE tbl_column_a (column_a  text(50), status text(50)) 
CREATE TABLE tbl_column_b (column_b  text(50), status text(50))

You import your column A in table tbl_column_a in column_a of the table
and you import your column B in table tbl_column_b in column_b of the table

Now you can run an update statement to mark the record

UPDATE TBL_COLUMN_A AS TBL_A  
SET  
TBL_A.STATUS = "ACTIVE" 
WHERE  
EXISTS (SELECT  1 FROM   TBL_COLUMN_B TBL_b WHERE TBL_A.COLUMN_A=TBL_B.COLUMN_B);

or you can run a select statement to find out what is present in one and not in other ( you can use Access. Some thing like this

SELECT  
TBL_COLUMN_B.COLUMN_B,  
'INACTIVE' AS number_status 
FROM  
TBL_COLUMN_A 
RIGHT  JOIN TBL_COLUMN_B  
  ON TBL_COLUMN_A.COLUMN_A = TBL_COLUMN_B.COLUMN_B 
WHERE (TBL_COLUMN_A.COLUMN_A Is Null);