Match and Vlookup issue
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)),"M atch",""))
This is also more efficient because IF() will evaluate the second
MATCH only if the first ones fails.
|