D
Don Kline
I need to do a lookup in which I am get the date and value of a transaction
from a continuous listing of dates.
Entire range for the data is R2C1:R1215C10
Column 1 has the dates starting with 3/16/2006 and end 5/29/2009. The dates
in this column mark an actual transaction.
Column 2 has the value I need to look up - the value of the transacation
Column 9 has the dates on a continuous daily basis - starting with
3/16/2006, next date is 3/17/2006, etc.
Column 10 is where I want the result of the looked up values
So if the next transaction is on 4/1/2006, the value of that transaction
($950.40) will be in Column 10 on that matching day of 4/1/2006.
I've tried puttering around with Match and Index but the solution is eluding
me at this point.
from a continuous listing of dates.
Entire range for the data is R2C1:R1215C10
Column 1 has the dates starting with 3/16/2006 and end 5/29/2009. The dates
in this column mark an actual transaction.
Column 2 has the value I need to look up - the value of the transacation
Column 9 has the dates on a continuous daily basis - starting with
3/16/2006, next date is 3/17/2006, etc.
Column 10 is where I want the result of the looked up values
So if the next transaction is on 4/1/2006, the value of that transaction
($950.40) will be in Column 10 on that matching day of 4/1/2006.
I've tried puttering around with Match and Index but the solution is eluding
me at this point.