Either there is a difference in the characters that make up those entries. Or
one of the values is text even though it's comprised of all digits.

You can test by picking out the two cells that you know are the same.

Then use:
=a10='sheet2'!aa23

If that's false, then try this in two more empty cells:

=isnumber(a10)
and
=isnumber('sheet2'!aa23

If one of those is true and the other is false, then you can either change the
formula or fix the data.

nishkrish wrote:

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


--

Dave Peterson