Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookup Error in Part of a Named Range Dallas64 Excel Worksheet Functions 6 April 18th 06 02:13 PM
dynamic named range function MJB Excel Worksheet Functions 1 August 5th 05 05:56 AM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
referencing named formula using INDIRECT function [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"