Can OR be used within MATCH

J

Joe Gieder

First, thank you for looking at this and your help.
I'm trying to use the formula below to tell me if a cell value in I3 is
listed in either A6:A2260 OR B6:B2260
=IF(ISNUMBER(MATCH($I3,OR(('MSP Listing'!$A$6:$A$2260),('MSP
Listing'!$B$6:$B$2260)),0)),"Yes","No")
Can this be accomplished in this condensed formula or do I need to write a
multiple IF formula? The way it's written above I receive No but the part
does exist in A, it should say Yes.

Again, thank you for all your help
Joe
 
B

bpeltzer

I'd just apply the OR to multiple ISNUMBER(MATCH()) constructs:
=if(or(isnumber(match($I3,'MSP
Listing'!$A$6:$A$2260,0)),isnumber(match($I3,'MSP
Listing'!$B$6:$B$2260,0))),"Yes","No")
 
J

Joe Gieder

Thank you. I just had the OR in the wrong place.

bpeltzer said:
I'd just apply the OR to multiple ISNUMBER(MATCH()) constructs:
=if(or(isnumber(match($I3,'MSP
Listing'!$A$6:$A$2260,0)),isnumber(match($I3,'MSP
Listing'!$B$6:$B$2260,0))),"Yes","No")
Click to expand...
 
B

Biff

Another way:

=IF(COUNTIF('MSP Listing'!A6:B2260,I3),"Yes","No")

Or, for a simple TRUE or FALSE:

=COUNTIF(Sheet2!A1:B10,I3)>0

Biff
 
Top