Bingo! My mind got stuck in having to use the OR statement. It works
perfectly. Thank you!

Frank

On Mon, 20 Jun 2011 15:05:18 -0700 (PDT), joeu2004
wrote:

On Jun 20, 1:10*pm, Phrank wrote:
=IF(OR(MATCH($A3,'Current'!$A$2:$A$100,0)0,
MATCH($A3,'Waiting'!$A$2:$A$100,0)0),"Match","")

That does not work because if either MATCH expression fails and
returns the #N/A error, OR() will return an error.

Try:

=IF(ISNUMBER(MATCH($A3,'Current'!$A$2:$A$100,0)), "Match",
IF(ISNUMBER(MATCH($A3,'Waiting'!$A$2:$A$100,0))," Match",""))

This is also more efficient because IF() will evaluate the second
MATCH only if the first ones fails.