IF Function: Lookup value needs to reference other worksheets
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.
|