HYPERLINK FORMULA not working properly

[Chica45504]

=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.

 

[Fluff]

Hi & welcome to MrExcel.
With the 1st formula are you trying to find the 13th smallest value in Table1[Date and time]?

 

[Chica45504]

yes, It is a calendar that I have working correctly minus the hyperlink to the cell the bad link brings back the right info, just that the hyperlink takes me to the wrong cell.

 

[Fluff]

In that case best guess is that B78 is the same value as B90

 

[Chica45504]

B78 = 302
B90 = TEXT


Where is the formula picking up the hyperlink? I am not too familiar with that.

 

[Fluff]

Sorry, I should have said the both the 78th & 90th row of Table1[Date and time] have the same value.

 

[Chica45504]

they do not have the same value.

 

[Fluff]

In that case can you some sample data that shows the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.