Okay I went back to what I tried for the test sheet that I uploaded and my formula went something like this...
=SLOPE(ADDRESS(MATCH('Calculation Sheet'!$B$5,'Data to be referenced in sheet'!C:C,1),3,1,1,"'Data to be referenced in sheet'!"):ADDRESS(MATCH('Calculation Sheet'!$C$5,'Data to be referenced in sheet'!C:C,1),3,1,1,"'Data to be referenced in sheet'!"),ADDRESS(MATCH('Calculation Sheet'!$B$5,'Data to be referenced in sheet'!C:C,1),4,1,1,"'Data to be referenced in sheet'!"):ADDRESS(MATCH('Calculation Sheet'!$C$5,'Data to be referenced in sheet'!C:C,1),4,1,1,"'Data to be referenced in sheet'!"))
I guess you can't do slope(address():address(),address():address()). Idk I'm relatively new to this whole reference function game
Bookmarks