N
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
one worksheet to column b of another worksheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
=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.
D
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.
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
N
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.
cause i dont know in what cell that number is located in sheet 2 column will
be aa but cell not sure.
D
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?
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.
N
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.
i was trying to find easy way out.
D
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.
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
Dave Peterson said: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?