how about the following - looking at columns a:d for "thing"

if(and(countif(a:a,"thing")0,countif(b:b,"thing") 0,countif(c:c,"thing")0,countif(c:c,"thing")0), "thing","")

search for at least one occurance of "thing" in each of columns a:d


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=374133