You can use a formula like this:

=isnumber(match(a1,sheet2!b:b,0))
to return True if the value in A1 matches any of the values in column B of
sheet2. It'll return False if there is no match.

=a1=sheet2!b1
will compare two cells

Not sure what you wanted.

nishkrish wrote:

is there a built in program in excel which i can use to compare column a of
one worksheet to column b of another worksheet
--
Nisha P

--

Dave Peterson