Formula in Clickable button

[Hemanth16]

Hey guys ,im having trouble inserting a formula into a shape..and making it work
can someone help me with it

The Formula....=HYPERLINK("[6.Shop Workers.xlsx]"&ADDRESS(1,1,,,$G$3),"Click")

0.Overall Look.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2
3			101				Jebastin										Salary Date
4
5																	01-08-2020
6
7
8							Salary				10,000
9
10
11
12			Leave			0				Click					Total Salary			10,000
13
14
15
16								Amount Given				-				Oneday Salary		333
17
18
19
20
21
Workers

Cell Formulas
Range	Formula
G3	G3	=IF(C3>0,VLOOKUP($C$3,'H:\Work\[6.Shop Workers.xlsx]Index'!$B:$I,2,0),"Name")
Q5	Q5	=IF(C3>0,VLOOKUP($C$3,'H:\Work\[6.Shop Workers.xlsx]Index'!$B:$I,3,0),"")
K8	K8	=IF(C3>0,R12-((R16*F12)+L16),)
F12	F12	=IF(C3>0,VLOOKUP($C$3,'H:\Work\[6.Shop Workers.xlsx]Index'!$B:$I,6,0),)
J12	J12	=HYPERLINK("[6.Shop Workers.xlsx]"&ADDRESS(1,1,,,$G$3),"Click")
R12	R12	=IF(C3,VLOOKUP($C$3,'H:\Work\[6.Shop Workers.xlsx]Index'!$B:$I,4,0),)
L16	L16	=IF(C3>0,VLOOKUP($C$3,'H:\Work\[6.Shop Workers.xlsx]Index'!$B:$I,7,0),)
R16	R16	=IF(C3>0,VLOOKUP($C$3,'H:\Work\[6.Shop Workers.xlsx]Index'!$B:$I,5,0),)

 

[6StringJazzer]

What doesn't work--what are you expecting and what happens instead?

What is the value in G3? You may need quotes around the file/sheet qualifier:

=HYPERLINK("'[6.Shop Workers.xlsx]"&$G$3&"'!"&ADDRESS(1,1) ,"Click")