Macro Code With VLOOKUP On Dates

I'm trying to look up a value in Analytics Data searchin for the date in B9 to B & rader.

I get error messages, because i can't find the dates. But I'm sure I have defined the ranges correct. The code works in another workbook with the difference that the table with the variables I'm trying to lookup are in the same sheet as the where I want to place them.



Private Sub Upd1_Click()
Dim rader As Double

Dim lookrng As range
Dim updvalue0 As Double
Dim updvalue1 As Double
Dim updvalue2 As Double
Dim updvalue3 As Double
Dim updvalue4 As Double
Dim updvalue5 As Double .........