One way that is compatible between versions...

Enter this formula in column C and copy to the end of data in column B:

=IF(COUNTIF(A$1:A$15,B1),"x","")

"x" marks items in both columns.

--
Biff
Microsoft Excel MVP


"vhagerty" wrote in message
...
I'm using Excell 2007 and need to figure out a way to take the cells in
column A (text) and check to see if they are in column B. If so identify
them some way in column B. Hopefully this can also be compatible with
Excell
2003 also.