No both formulas give out false value i have same numbers in two different
work sheet what i want is it should check if sheet 1 column a10 matches the
same number in sheet 2 at column aa23 basically it should match the number
like

Sheet 1

column A

3000111009806550
3000111009106790
3000111109862360
3000110909152070

The same number are avaiable in sheet2 but dont know what row number




--
Nisha P


"Dave Peterson" wrote:

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