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