Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
ok I have a workbook with sheets named by month (Sep, Oct, Nov...) I have a
sheet named Weekly. In Weekly I have a LOOKUP function as such. =LOOKUP(B1,Oct!$B$4:$B$34,Oct!$E$4:$E$34) B1 = Date in Weekly to lookup. Oct! = the sheet to look in. I'm looking for a way to have the Oct referance be determined via cell referance. I tried some codes but just can't get this to work. I know I would do a TEXT(B1,"mmm") to get "Oct" trouble is setting up my original code to do this. I've also been tryingto do it with INDIRECT function but to also no result. I know it's just a wrong " or , somewhere. |
#2
![]() |
|||
|
|||
![]()
One way:
=LOOKUP(B1,INDIRECT("'" & C1 & "'!B4:B34"),INDIRECT("'" & C1 & "'!E4:E34")) Note that the single quotes are only necessary if C1 may have a space in the text. In article , "Mike Punko" wrote: ok I have a workbook with sheets named by month (Sep, Oct, Nov...) I have a sheet named Weekly. In Weekly I have a LOOKUP function as such. =LOOKUP(B1,Oct!$B$4:$B$34,Oct!$E$4:$E$34) B1 = Date in Weekly to lookup. Oct! = the sheet to look in. I'm looking for a way to have the Oct referance be determined via cell referance. I tried some codes but just can't get this to work. I know I would do a TEXT(B1,"mmm") to get "Oct" trouble is setting up my original code to do this. I've also been tryingto do it with INDIRECT function but to also no result. I know it's just a wrong " or , somewhere. |
#3
![]() |
|||
|
|||
![]()
Thanks man. I knew it was somethign simple I wsa forgetting the single quotes.
"JE McGimpsey" wrote: One way: =LOOKUP(B1,INDIRECT("'" & C1 & "'!B4:B34"),INDIRECT("'" & C1 & "'!E4:E34")) Note that the single quotes are only necessary if C1 may have a space in the text. In article , "Mike Punko" wrote: ok I have a workbook with sheets named by month (Sep, Oct, Nov...) I have a sheet named Weekly. In Weekly I have a LOOKUP function as such. =LOOKUP(B1,Oct!$B$4:$B$34,Oct!$E$4:$E$34) B1 = Date in Weekly to lookup. Oct! = the sheet to look in. I'm looking for a way to have the Oct referance be determined via cell referance. I tried some codes but just can't get this to work. I know I would do a TEXT(B1,"mmm") to get "Oct" trouble is setting up my original code to do this. I've also been tryingto do it with INDIRECT function but to also no result. I know it's just a wrong " or , somewhere. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |