Finding a value within two rows
 

First, thank you for your help.
Is there a way to take a value from one cell say A1 and look within two
other rows say B1:B1000 and C1:C1000 and if there's a match say "Yes"?

Thank you
Joe

Finding a value within two rows
 

Try...

=IF(COUNTIF(B1:C1000,A1),"Yes","")

Hope this helps!

In article ,
"Joe Gieder" wrote:

First, thank you for your help.
Is there a way to take a value from one cell say A1 and look within two
other rows say B1:B1000 and C1:C1000 and if there's a match say "Yes"?

Thank you
Joe

Finding a value within two rows
 

I'm sure there is a better way to do this, and I'm sure someone else will
come up with it. But in the meantime, this should work for your situation

=IF(ISERROR(MATCH(A1,B1:B1000,0)),IF(ISERROR(MATCH (A1,C1:C1000,0)),"No","Yes"),"Yes")

Of course you can put what you want to show up in the cell in place of "Yes"
and "No"

- Search

"Joe Gieder" wrote:

First, thank you for your help.
Is there a way to take a value from one cell say A1 and look within two
other rows say B1:B1000 and C1:C1000 and if there's a match say "Yes"?

Thank you
Joe

Finding a value within two rows
 

=IF(OR(ISNUMBER(MATCH(A1,B1:B1000,0)),ISNUMBER(MAT CH(A1,C1:C1000,0))),"Yes",
"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe Gieder" wrote in message
...
First, thank you for your help.
Is there a way to take a value from one cell say A1 and look within two
other rows say B1:B1000 and C1:C1000 and if there's a match say "Yes"?

Thank you
Joe

Finding a value within two rows
 

Hi,

You may also try the following array formula (Ctrl+Shift+Enter)

=or(exact(A1,B1:C1000))

Regards,

Ashish Mathur


"Joe Gieder" wrote:

First, thank you for your help.
Is there a way to take a value from one cell say A1 and look within two
other rows say B1:B1000 and C1:C1000 and if there's a match say "Yes"?

Thank you
Joe

Finding a value within two rows
 

Thank you all for the help.

"Joe Gieder" wrote:

First, thank you for your help.
Is there a way to take a value from one cell say A1 and look within two
other rows say B1:B1000 and C1:C1000 and if there's a match say "Yes"?

Thank you
Joe