LINEST() Help

Hi Folks,

New to the forum! I'm trying to write a LINEST function that allows the user to specify the appropriate ranges for x and y using the following (file also attached):

=linest(text(CELL("address",INDEX($A$8:$E$17,MATCH(B29,$E$8:$E$17, 0),5)),"0"):text(CELL("address",INDEX($A$8:$E$17,MATCH(C29,$E$8:$E$17, 0),5)),"0"),text(CELL("address",INDEX($A$8:$E$17,MATCH(B28,$B$8:$B$17, 0),2)),"0"):text(CELL("address",INDEX($A$8:$E$17,MATCH(C28,$B$8:$B$17, 0),2)),"0"),true,false)

For some reason the CELL(INDEX(MATCH( combo isn't yielding a format that the LINEST function can use to create a range. My ultimate goal is to obtain the slope and y-intercept for two lines of best fit, then solve for the point of intersection.

Thanks in advance for your help!

Consolidation Parameters.xlsx

Yes, that did the trick - thanks for your help!!