Cell Address Hyperlink

[MrDB4Excel]

In one workbook, in cell P2, I am using the formula: =MIN($O$4:$O$622) and in an adjacent cell, Z2, in the same workbook I am using the formula: =CELL("address",INDEX(O:O,MATCH(MIN(O:O),O:O,0))).
The result in Z2 gives the address of the minimum value within O4:O622.
This cell address then shows in a different workbook, @ E13, via the use of ='[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$Z$2.
What I would like is to hyperlink to FortissimoTabulation2023.xlsx, Sheet DailyRate1Apr2022-31Mar2023 and specifically to the cell address indicated by Z2 in FortissimoTabulation2023.xlsx, Sheet DailyRate1Apr2022-31Mar2023 which incidentally may change. Today cell Z2 shows a cell address of $O$6 but tomorrow, or next week or next month at a moment's notice cell Z2 could indicate a different cell address for the minimum value with O4:O622.
I have tried all the hyperlink formulas and options I can think of and that I have used in the past but nothing seems to get this going in a good direction.
Any help will be much appreciated.

FortissimoTabulation2023.xlsx
	O	P	Q	R	S	T	U	V	W	X	Y	Z
1					Extra Dates Per Specific Rate	Day	Month	486	488	488	B Col Count	Fri-01 April 2022
2	Min ððð	62,341.30 Kč		2,900						$B$488	486	$O$6
3	Max ððð	72,444.90 Kč		3,100							20	$O$298
4	62,564.60 Kč		1	2,900
DailyRate1Apr2022-31Mar2023

Cell Formulas
Range	Formula
V1	V1	=EXTRACTNUMBERS(Y2,TRUE)
W1	W1	=SUM(V1+2)
X1	X1	=EXTRACTNUMBERS(W1)
X2	X2	=ADDRESS(X1,2)
Y2	Y2	=COUNTA(E:E)
P2	P2	=MIN($O$4:$O$622)
P3	P3	=MAX($O$4:$O$622)
Z1	Z1	=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$4:$B$555)/($B$4:$B$555<>0),ROWS($Z$1:Z1))),"")
Z2	Z2	=CELL("address",INDEX(O:O,MATCH(MIN(O:O),O:O,0)))
Z3	Z3	=CELL("address",INDEX(O:O,MATCH(MAX(O:O),O:O,0)))
O4	O4	=IFERROR(IF(SUM(C4*R4)=0,"",(SUM(C4*R4))),"")
R4	R4	=IF(YEAR(B4)=2022,$R$2,IF(YEAR(B4)=2023,$R$3,""))

FortissimoTabulation2023.xlsx
	O	P	Q	R	S	T	U	V	W	X	Y	Z
1					Extra Dates Per Specific Rate			2	4	4	B Col Count	Thu-01 June 2023
2	Min ððð	0.00 Kč		2,900						$B$4	2	#N/A
3	Max ððð	0.00 Kč		3,100							20	#N/A
4			1	3,100		1
DailyRate1Apr2023-31Mar2024

Cell Formulas
Range	Formula
V1	V1	=EXTRACTNUMBERS(Y2,TRUE)
W1	W1	=SUM(V1+2)
X1	X1	=EXTRACTNUMBERS(W1)
X2	X2	=ADDRESS(X1,2)
Y2	Y2	=COUNTA(E:E)
P2	P2	=MIN($O$4:$O$251)
P3	P3	=MAX($O$4:$O$251)
Z2	Z2	=CELL("address",INDEX(O:O,MATCH(MIN(O:O),O:O,0)))
Z3	Z3	=CELL("address",INDEX(O:O,MATCH(MAX(O:O),O:O,0)))
O4	O4	=IFERROR(IF(SUM(C4*R4)=0,"",(SUM(C4*R4))),"")
R4	R4	=IF(YEAR(B4)=2022,$R$2,IF(YEAR(B4)=2023,$R$3,""))

This image is from the workbook EssentialDailyExcelFiles2023.xlsm which will not allow me to create a Mini Sheet; therefore the following formulas are resident in the cells indicated by this image:

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2023-31Mar2024'!$P$2

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2023-31Mar2024'!$P$3

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$P$2

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$P$3

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$Z$2

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$Z$3

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2023-31Mar2024'!$Z$2

='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2023-31Mar2024'!$Z$3

 

[MrDB4Excel]

Not sure how to do this but I discovered the solution so I don't need any response.
Would someone please tell me the correct way to indicate I have found a solution?

 

[Georgiboy]

Maybe post the solution and mark it as the answer, that way if someone looks at this in the future when it comes up in a search - they will have the answer.

 

[MrDB4Excel]

I believe a partial answer will suffice. Partial in that the original post showed 4 rows regarding links to 4 cell addresses which really are all similar with respect to the solution thus only one row showing all parts of the solution should be enough.

The following is the final answer. I just needed to get all the parts correct. I followed previous examples of this scenario in other worksheets in which I use this same function.

FortissimoTabulation2023.xlsx
	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1					Extra Dates Per Specific Rate	Day	Month	488	490	490	B Col Count	Fri-01 April 2022
2	Min ððð	62,341.30 Kč		2,900						$B$490	488	$O$6	6
3	Max ððð	72,444.90 Kč		3,100							20	$O$298	298
4	62,564.60 Kč		1	2,900
5			0
6	62,341.30 Kč		1	2,900	Jan 23, 2023 07:47:40
DailyRate1Apr2022-31Mar2023

Cell Formulas
Range	Formula
V1	V1	=EXTRACTNUMBERS(Y2,TRUE)
W1	W1	=SUM(V1+2)
X1	X1	=EXTRACTNUMBERS(W1)
Z1	Z1	=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$4:$B$555)/($B$4:$B$555<>0),ROWS($Z$1:Z1))),"")
X2	X2	=ADDRESS(X1,2)
Y2	Y2	=COUNTA(E:E)
Z2	Z2	=CELL("address",INDEX(O:O,MATCH(MIN(O:O),O:O,0)))
AA2:AA3	AA2	=RIGHT(Z2,LEN(Z2)-FIND(CHAR(160),SUBSTITUTE(Z2,"$",CHAR(160),2)))
Z3	Z3	=CELL("address",INDEX(O:O,MATCH(MAX(O:O),O:O,0)))
P2	P2	=MIN($O$4:$O$622)
P3	P3	=MAX($O$4:$O$622)
O4,O6	O4	=IFERROR(IF(SUM(C4*R4)=0,"",(SUM(C4*R4))),"")
R4,R6	R4	=IF(YEAR(B4)=2022,$R$2,IF(YEAR(B4)=2023,$R$3,""))
Q5:Q6	Q5	=MOD(ROWS(Q$2:Q3),2)

TempMrExcelPost.xlsx
	C	D	E	F	G	H	I	J	K
15	62,341.30 Kč	ïïï Apr2022-Mar2023 MIN Fortissimo	$O$6	ïïï Apr2023-Mar2024 Minimum Cell Address			6	$O$6	$O$6
Sheet1

Cell Formulas
Range	Formula
C15	C15	='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$P$2
E15	E15	=HYPERLINK("[FortissimoTabulation2023.xlsx]'DailyRate1Apr2022-31Mar2023'!o"&(COUNTA(AV:AV)+$I$15),$J$15)
I15	I15	='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$AA$2
J15	J15	=$K$15
K15	K15	='F:\Finances\CSOB\2023\[FortissimoTabulation2023.xlsx]DailyRate1Apr2022-31Mar2023'!$Z$2

I hope this answers anyone's search for an answer to this post, if not be sure to contact me.

As a side note. The ððð & ïïï you see are Wingding arrows that do not come across using the Xl2bb Mini Sheet.

 

[Georgiboy]

Thanks for posting the solution,

I did wonder about the ððð so thanks for clearing that up also. I thought that ïïï looked like three people waving...

 

[MrDB4Excel]

You are most welcome.
Glad I could help.