First of all, am sorry if this was already posted by someone else, I tried searching for hours now, but did not find something similar to what I have here. I am very newb on excel.
My problem is, I have data from 2000 to present, on two different commodities, Coffee and also USD vs BRL (American Dollar vs Brazilian currency). The Coffee market only works certain days (no weekends or holidays) while the currency exchange works 24/7. So I have found data for both, however there is way more data on the currency than there is on coffee, and I want to merge both together to make a two axis chart.
I made the following code: =VLOOKUP([Date],USDBRL,USDBRL[USD/BRL]) Where [DATE] is the table I have for coffee and I want the USDxBRL next to the corresponding date. USDBRL is the table where I have all the value for the currency exchange rate. USDBRL[USD/BRL] is the column with the currency exchange rate
I am getting the following results: 36528 (equals to January, 03, 2000) on the first line, and it's the same date, but I should be getting 1.8055, which is the rate that I want... and the lines below are all the same +1 (increasing dates)
"Funny" part is that, if I scroll down a little bit more (to August 23, 2001) I start getting the actual results that I want, it is then showing the currency exchange rate that I need.
How can I copy the correct data? I uploaded a small version of my excel here.
I thank you in advance if you can help me out with this, been banging my head for hours now.