Match and Vlookup issue
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.
|