Using Function to call Woorbook Sheet
 

I would like to use WEEKDAY() to call a particular Sheet in a Wookbook. The
Sheets are called Sunday - Saturday and I have an IF statement that needs to
check for particular information on that sheet depending on what day it is.
Have it currently functioning but it is taking up way to much space. I am
unable to update my code with other functions that I need it to calculate
until I can figure this part out.

Code:
=IF(OR(AND((TEXT(TODAY(),"dddd")="Monday"),(HLOOKU P(MOD(NOW(),1),Monday!$B$1:$BA$40,2))0),AND((TEXT (TODAY(),"dddd")="Tuesday"),(HLOOKUP(MOD(NOW(),1), Tuesday!$B$1:$BA$40,2))0),AND((TEXT(TODAY(),"dddd ")="Wednesday"),(HLOOKUP(MOD(NOW(),1),Wednesday!$B $1:$BA$40,2))0),AND((TEXT(TODAY(),"dddd")="Thursd ay"),(HLOOKUP(MOD(NOW(),1),Thursday!$B$1:$BA$40,2) )0),AND((TEXT(TODAY(),"dddd")="Friday"),(HLOOKUP( MOD(NOW(),1),Friday!$B$1:$BA$40,2))0),AND((TEXT(T ODAY(),"dddd")="Saturday"),(HLOOKUP(MOD(NOW(),1),S aturday!$B$1:$BA$40,2))0)),"y","")

As you can see it would be much easier if I could just do
=IF (HLOOKUP(MOD(NOW(),1),WEEKDAY()!$B$1:$BA$40,2))0)
but obviously that does not work.

Thank you in advance

Hi
try:
=HLOOKUP(MOD(NOW(),1),INDIRECT("'" & TEXT(TODAY(),"dddd") &
"'!$B$1:$BA$40"),2)....

--
Regards
Frank Kabel
Frankfurt, Germany

"Tahlmorrah" schrieb im
Newsbeitrag ...
I would like to use WEEKDAY() to call a particular Sheet in a
Wookbook. The
Sheets are called Sunday - Saturday and I have an IF statement that
needs to
check for particular information on that sheet depending on what day
it is.
Have it currently functioning but it is taking up way to much space.
I am
unable to update my code with other functions that I need it to
calculate
until I can figure this part out.

Code:

=IF(OR(AND((TEXT(TODAY(),"dddd")="Monday"),(HLOOKU P(MOD(NOW(),1),Monday
!$B$1:$BA$40,2))0),AND((TEXT(TODAY(),"dddd")="Tue sday"),(HLOOKUP(MOD(N
OW(),1),Tuesday!$B$1:$BA$40,2))0),AND((TEXT(TODAY (),"dddd")="Wednesday
"),(HLOOKUP(MOD(NOW(),1),Wednesday!$B$1:$BA$40,2)) 0),AND((TEXT(TODAY()
,"dddd")="Thursday"),(HLOOKUP(MOD(NOW(),1),Thursda y!$B$1:$BA$40,2))0),
AND((TEXT(TODAY(),"dddd")="Friday"),(HLOOKUP(MOD(N OW(),1),Friday!$B$1:$
BA$40,2))0),AND((TEXT(TODAY(),"dddd")="Saturday") ,(HLOOKUP(MOD(NOW(),1
),Saturday!$B$1:$BA$40,2))0)),"y","")

As you can see it would be much easier if I could just do
=IF (HLOOKUP(MOD(NOW(),1),WEEKDAY()!$B$1:$BA$40,2))0)
but obviously that does not work.

Thank you in advance