| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using lookup function | Excel Discussion (Misc queries) | |||
| Lookup function problem (kg) | Excel Worksheet Functions | |||
| Lookup function skipping columns | Excel Worksheet Functions | |||
| Lookup function returning reference, not value | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
