software

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)),quot;Yesquot;,quot;Noquot;)
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
JoeI'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))),quot;Yesquot;,quot;Noquot;)

quot;Joe Giederquot; wrote:

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

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

quot;bpeltzerquot; wrote:

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

Another way:

=IF(COUNTIF('MSP Listing'!A6:B2260,I3),quot;Yesquot;,quot;Noquot;)

Or, for a simple TRUE or FALSE:

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

Biff

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