This is great - and works - however we will have over 100 worksheets... is
there a simpler way? Else this AND statement will become VERy VERy long.


"Bernie Deitrick" wrote:

Danielle,

=IF(AND(Recipient1!E2="Partner",Recipient2!E2="Par tner",Recipient3!E2="Partner"), "yes","no")

HTH,
Bernie
MS Excel MVP


"Danielle" wrote in message
...
I am trying to reference other worksheet to be in the value of the lookup but
get #REF error. Is it not possible to reference other cells in multiple
worksheets

ie: =IF(Recipient1:Recipient3!E2="Partner", "yes","no")

I want to ask if e2 (on all worksheets) state the word "Partner" then say
Yes or No.

Eventually I want it to average the number together - but let's just start
with this simple question.

D.