Hi Senthil
This can be achieved by using an Array formula. There are some rules that must be followed for it to work. Firstly both columns of data and the results column must have exactly the same number of cells in them. Secondly when you have typed in the formula in the formula bar it must be entered by hitting the shift, ctrl and enter keys at the same time. I will give you an example to try out.
You have two columns of data List 1 and List 2.
List 1 is E15:E23 and List 2 is G17:G25 (note they do not have to start at the same row but MUST have the same number of rows, they can of course start at the same row if you wish). Now highlight the same number of rows in a different column. Then in the formula bar type in the formula:-
=IF(ISERROR(MATCH(E15:E23,G17:G25,0)),E15:E23,"")
As mentioned before you must hit shift, ctrl and enter keys simultaneously for the array formula to be activated. You will know if the Array is activated as the formula you entered in the formula bar will have a "squiggle" at the beginning and end of it. You must also enter it in the same manner whenever you change the formula.
Hope this helps - Rod