Book1 is a sporadic list of dates with values.
Book2 is longer list of dates based on business days in the calendar. I want to pull the B column value in Book 1 to the B column in Book 2 with the matching date and if there is no matching date, a 0 should be used.
I have setup the Lookup formula but it is keeping the value at the previous value instead of 0 when there is no match.
I need the formula for this.