Finding a value within two rows

[Guest]

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

 

[Domenic]

Try...

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

Hope this helps!

 

[Guest]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

Hi,

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

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

Regards,

Ashish Mathur

 

[Guest]

Thank you all for the help.