|*||4/1/13||Merged Cell||4/2/13||Merged Cell|
|Interval||Forecasted sales||Actual Sales||Forecasted sales||Actual Sales|
My formatting of the sheet goes on continuously to the right for month of April. What I have is two formulas that calculate the current interval and current date, I want to use those to triangulate the actual sales for that interval. Example: Say it's 8:00 and it's 4/2/13, I want to find "35" on "Actual Sales of the 4/2/13.
The reason it has to be offset is because this is a formatted report that has the dates merged over the data to report to management. So I'm assuming it would be a mix of an index and match and would need to be offsetted from the date column to get to the "Actual Sales" column to get the 35 on 4/2/13 at 8:00.
Thanks for your time!