Hi guys, anyway someone would be able to change this to INDIRECT which references the worksheet to target in a 'Register'!$K$23?
So where it says 'Chiller PM' instead of it being that. instead being referenced to K23 on sheet 'Register'. (Which will be the sheet to target in K23)
Please Login or Register to view this content.
similar to this other one im using in a way.ThanksPlease Login or Register to view this content.
Last edited by LeeBillington; 07-18-2018 at 02:13 PM.
Presumably
=(IFERROR(INDEX(Indirect("'"&K23&"'!"K23)&......blah blah
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I tried doing it myself and couldn't do it.. kept messing it up somehow. hence why i asked if someone could? sorry if i didn't explain that.
Try
=(IFERROR(INDEX(INDIRECT("'"&Register!$K$23&"'!$G$1:$XFD$1"),SMALL(IF(INDEX(INDIRECT("'"&Register!$K$23&"'!$G$31:$XFD$1900"),MATCH('Holiday - Registers'!$C$3,INDIRECT("'"&Register!$K$23&"'!$C$31:$C$1900"),0),)>0,COLUMN($G:$XFD)-6),ROWS($1:2))),""))
Worked Perfectly, thanks jonmo1
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks