Originally Posted by CunningSmeagol
I was thinking more =if(iserror(vlookup(date,listofdates,pricecolumn,false)),,vlookup(date,listofdates,pricecolumn,false))
Exactly. The problem I was talking about was where do the new dates/prices go? I think the easiest solution would be to create a new dataset by listing every date starting with the oldest date until today. Then you can use the...