| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to Named Range on another sheet for IF function
I'm sorry this may seem so simple, I've been searching and just can't find
the answer. I'm trying to do a simple IF function in cell B2 that looks at a cell (B1 - a date) on the activesheet and looks at a named range on another sheet (Sheet Name = Holidays, Range = A1:A15, is holiday dates). The holiday range on the holiday sheet can change so I can use specific cell references. I can't seem to get the formula to recognize both the page name and the range name in the formula. Can anyone help? Here is the formula I am trying to use: =IF(B1=Holidays!'Holidays',1,0) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refer to Named Range on another sheet for IF function
On Fri, 25 Aug 2006 18:42:02 -0700, David
wrote: I'm sorry this may seem so simple, I've been searching and just can't find the answer. I'm trying to do a simple IF function in cell B2 that looks at a cell (B1 - a date) on the activesheet and looks at a named range on another sheet (Sheet Name = Holidays, Range = A1:A15, is holiday dates). The holiday range on the holiday sheet can change so I can use specific cell references. I can't seem to get the formula to recognize both the page name and the range name in the formula. Can anyone help? Here is the formula I am trying to use: =IF(B1=Holidays!'Holidays',1,0) If the named range on the Holidays sheet is named Holidays, try this: =COUNTIF(Holidays,B1) --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refer to Named Range on another sheet for IF function
YOU ARE A LIFESAVER!! That got me what I need! Thank you VERY much!!
David "Ron Rosenfeld" wrote: On Fri, 25 Aug 2006 18:42:02 -0700, David wrote: I'm sorry this may seem so simple, I've been searching and just can't find the answer. I'm trying to do a simple IF function in cell B2 that looks at a cell (B1 - a date) on the activesheet and looks at a named range on another sheet (Sheet Name = Holidays, Range = A1:A15, is holiday dates). The holiday range on the holiday sheet can change so I can use specific cell references. I can't seem to get the formula to recognize both the page name and the range name in the formula. Can anyone help? Here is the formula I am trying to use: =IF(B1=Holidays!'Holidays',1,0) If the named range on the Holidays sheet is named Holidays, try this: =COUNTIF(Holidays,B1) --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refer to Named Range on another sheet for IF function
On Fri, 25 Aug 2006 19:36:01 -0700, David
wrote: YOU ARE A LIFESAVER!! That got me what I need! Thank you VERY much!! David You're welcome. Glad to help. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| dynamic named range function | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Linear Mode
