Unable to Find the slope together with Vlookup

Hi Guys,

I have the following problem.
I Need to calculate the slope to find my beta.
The 'known y's' are the market returns that can be found on the MSCI index worksheet. They depend from which I need the data from. I used therefore a Vlookup function to link the appropriate date (to be found on sheet1 at c8 until C9) with the appropriate returns on the MSCI index.
The 'known X's' are the stockreturns from the past year. I need them from every column from C62 until C 314.

I therefore ended up with the Following formula to get the slope: =Slope(VLOOKUP(C8,'MSCI index'!A4:G17223,6,FALSE):(VLOOKUP(C9,'MSCI index'!A4:G17223,6,false)),C62:C314)
But i always get in Return an error message, although i am 100 procent sure that my Vlookups are correct. Can anyone tell me what im doing wrong? The file is unfortunately too big to send.
I ve been trying now for the past 2 hours, i would much appreciate your help!

Best regards,

Robbie

You might try using the Evaluate Formula button on the Formula ribbon to check the intermedate stages in the evaluation of your formula. This is a very useful technique for debugging complex formulae.

If I do both Vlookups apart then they give the correct number that belongs to identifier. But it fails when i put the : in between the 2 lookups to reflect my range.

Suggest posting a cut down version of the workbook which replicates the issue.

No idea how to as everything is linked to my dataset. How can i save this as a zipfile?

its only 11 mb, so email is no problem

Suggest copy followed by Paste Special - Values to break the link. It will be interesting if the problem continues after this. Obviously only do this on a copy.