Chica45504
New Member
- Joined
- May 17, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
=IFERROR(HYPERLINK("[TESTTTTTT.xlsm]Schedule!$B$"&MATCH(SMALL(IF('Monthly view'!$K$3=INT(Table1[Date and time]),Table1[Date and time],""),ROW(A13)),Table1[Date and time],0)+2,SMALL(IF('Monthly view'!$K$3=INT(Table1[Date and time]),Table1[Date and time],""),ROW(A13))),"")
The above Hyperlink takes me to the wrong cell in Column B The above takes me to: [TESTTTTTT.xlsm}Schedule!$B$78 it Should take me to [TESTTTTTT.xlsm}Schedule!$B$90
The below Hyperlink works as it was designed to and takes me to the right cell in Column B
=IFERROR(HYPERLINK("[TESTTTTTT.xlsm]Schedule!$B$"&MATCH(SMALL(IF('Monthly view'!$K$3=INT(Table1[Date and time]),Table1[Date and time],""),ROW(A15)),Table1[Date and time],0)+2,SMALL(IF('Monthly view'!$K$3=INT(Table1[Date and time]),Table1[Date and time],""),ROW(A15))),"")
The above takes me to: [TESTTTTTT.xlsm}Schedule!$B$92 as it should
Please help me fix.
The above Hyperlink takes me to the wrong cell in Column B The above takes me to: [TESTTTTTT.xlsm}Schedule!$B$78 it Should take me to [TESTTTTTT.xlsm}Schedule!$B$90
The below Hyperlink works as it was designed to and takes me to the right cell in Column B
=IFERROR(HYPERLINK("[TESTTTTTT.xlsm]Schedule!$B$"&MATCH(SMALL(IF('Monthly view'!$K$3=INT(Table1[Date and time]),Table1[Date and time],""),ROW(A15)),Table1[Date and time],0)+2,SMALL(IF('Monthly view'!$K$3=INT(Table1[Date and time]),Table1[Date and time],""),ROW(A15))),"")
The above takes me to: [TESTTTTTT.xlsm}Schedule!$B$92 as it should
Please help me fix.