=SUMPRODUCT(--(Sheet2!$C$1:$C$50&Sheet2!$G$1:$G$50=Sheet2!C1&She et2!G1))=1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Andy Daugherty" wrote in message ...
Ok, one last question.
Everything works great for Sheet1, but I have Sheet2 and Sheet3 also.
I'm not sure where to place the Sheet numbers.

=SUMPRODUCT(--($C$1:$C$50&G$1:$G$50=C1&G1))=1