Can OR be used within MATCH
 

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

Can OR be used within MATCH
 

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")

"Joe Gieder" wrote:

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

Can OR be used within MATCH
 

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

"bpeltzer" wrote:

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")

"Joe Gieder" wrote:

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

Can OR be used within MATCH
 

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

"Joe Gieder" wrote in message
...
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