I have a date that I purchased fuel on. I want to lookup an effective date column either exactly or approximately to give me the appropriate rate.
Eg
Rate Eff Rate
01/01/02 .1
01/02/02 .2
01/03/02 .3
01/04/02 .4
Purchase date = 15/01/02
Rate should = .1
The Excel equivalent is Vlookup(PurchDate,Range,2)
I hope someone out there has overcome this issue.
Shane
Eg
Rate Eff Rate
01/01/02 .1
01/02/02 .2
01/03/02 .3
01/04/02 .4
Purchase date = 15/01/02
Rate should = .1
The Excel equivalent is Vlookup(PurchDate,Range,2)
I hope someone out there has overcome this issue.
Shane