compare column

[nishkrish]

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

 

[Dave Peterson]

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]

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

 

[Dave Peterson]

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.

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

 

[nishkrish]

i tried both both shows false, i am matching my cell 1 to cell of sheet2
cause i dont know in what cell that number is located in sheet 2 column will
be aa but cell not sure.

 

[Dave Peterson]

Do it manually. Find two cells that match. Then try the comparison formulas.

If you can't find a match manually, why do you think that there is a match?

i tried both both shows false, i am matching my cell 1 to cell of sheet2
cause i dont know in what cell that number is located in sheet 2 column will
be aa but cell not sure.

 

[nishkrish]

Manually it is there but i am suppose to ck one by one for the whole month so
i was trying to find easy way out.

 

[Dave Peterson]

What happened when you tried those formulas against the two cells that appeared
to be the same?

I'm guessing that they are not the same. They only look like it to your eyes.
Excel doesn't see them the same.

Either that or you made a mistake in your formulas. You never shared what you
used.

Manually it is there but i am suppose to ck one by one for the whole month so
i was trying to find easy way out.
--
Nisha P

Do it manually. Find two cells that match. Then try the comparison formulas.

If you can't find a match manually, why do you think that there is a match?