Here is a microsoft article that gives an example of how
to compare two columns:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;139882&Product=xlw

-----Original Message-----
Hi

I have a Column A with some numbers as IDs and Column B
with some
other IDs.What is the easiest way in which I can check if
each value in
column B exists in column A.Each column has nearly 5000
entries.

Thanks.


---
Message posted from http://www.ExcelForum.com/

.