...or do i need (if it's even possible) to pass a DATE RANGE value to the "lookup_value" argument of the vector
method LOOKUP function?
not sure how to properly describe the problem i'm having here, and i have not found any threads addressing this particular
issue. if there is, i apologize.
i'm running office 2003 pro on windows xp sp3.
it began when i made
this single-sheet workbook to keep track of my car's gas mileage. pretty straightforward. i record every fill up by entering
in the 5 column "fill in section":
date, mileage, trip mileage, gallons taken, and money spent.
3 more columns automatically calculate as follows:
dollars per gallon, miles per gallon, and while i was at it, dollars per mile (i was bored i guess, idk).
point, i felt it could do more, so i tried to figure a yearly/monthly/weekly fuel budget for miles driven, gallons used, and
money spent, as well as average miles per gallon for the year, month, etc (the weekly figure can just divide the monthly
figure by 4).
i've tried the manual approach with absurdly nested IF statements, i've tried LOOKUP using the vector method, but i can't
properly pass the month or year of the date column to the lookup_value...
this seems to be my problem/question in
do i need (or is it possible) to pass a DATE RANGE value to the "lookup_value" argument?
i can imagine
it's WAY more simple and basic than i'm making this out to be. and for that, i apologize. i imagine it would look like i
don't have the vaguest clue what i'm doing. it's quite possible i'm simply missing something so simple and so painfully
any help, hints, or general advice here would be tremendously and thoroughly appreciated.
if there's anything i might have left out, please let me know. many thanks in advance for bearing with me. ~