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