On Tue, 4 Dec 2007 10:05:02 -0800, CFR wrote:

Thanks, Ron and Stefi.

Ron's suggestion ALMOST works - except that COUNTIF expects arguments
COUNTIF(range,criteria).

Keeping it at one range only to simplify, that would make it
=IF(COUNTIF('Sheet2!'rng1,"*"&B1&"*"...???) = 0,"No","Yes")

Can you please help with the ...???
TIA!

CFR

Just reverse the arguments I posted. (I didn't test it and had the range and
criteria reversed).
--ron