Find a couple of empty cells.

Put this in one:
=grp1!a261=grp2!a265

and put this in the other:
=grp1!b261=grp2!b265

Do you get Trues for both of these?

If you don't look for extra spaces, numbers treated as text in the offending
cells.

manasi wrote:

Some of the combinations which existed in Grp1 and also Grp2 were
showing up as False.

For ex: in row 261 i had 51/63
going to Grp2 row 265 had 51/63 but the formula evaluated to False on
Grp1 which meant there is no combination on Grp2 which is not true.
Please suggest me.

--
manasi
------------------------------------------------------------------------
manasi's Profile: http://www.excelforum.com/member.php...o&userid=27411
View this thread: http://www.excelforum.com/showthread...hreadid=469228

--

Dave Peterson