Hi guys, anyway someone would be able to change this to INDIRECT which references the worksheet to target in a 'Register'!$K$23?
=(IFERROR(INDEX('Chiller PM'!$G$1:$XFD$1,SMALL(IF(INDEX('Chiller PM'!$G$31:$XFD$1900,MATCH('Holiday - Registers'!$C$3,'Chiller PM'!$C$31:$C$1900,0),)>0,COLUMN('Chiller PM'!$G:$XFD)-6),ROWS($1:2))),""))
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)
similar to this other one im using in a way.
=IFERROR(VLOOKUP(C4,INDIRECT("'"&Register!$K$23&"'!$C$23:$XFD$1900"),MATCH(D4,INDIRECT("'"&Register!$K$23&"'!$C$1:$XFD$1"),0),0),"")
Thanks
Bookmarks