Application.VLookup returns ZERO instead of a number

Hi,

I have spent too many hours on this simple macro which just doesn't seem to work ultimately.

I am trying to bring data from one excel sheet into another using VLookup. The two sheets have different time frequencies in that one is weekly and the other daily. My code returns NA's instead of integers.

The problem is with the Application.VLookup. Here is my code and I would be grateful for any help!

Range("g" & i) = Application.VLookup (last_fri, Range("Weekly!$a$5:$h$1500"), 8, 0)

Note: msgbox(last_fri) already returns the correct value; a date. The value I am aiming to retrieve is in the 8th column of the sheet"Weekly".

Thanks,
Darius