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