how to return data based on data in a corresponding-sister cell

[protocel3]

Ok, I have been trying to figure this out for about a month now, but I just can't find a formula that will do what I want. I am trying to improve on my budget workbook, make it do a few more things automagically. In my budget workbook, I have 1 sheet for the budget and several others as trackers to be able to track where and how much I am spending in specific categories (i.e. gas, groceries, dining out, etc.). On my budget sheet I have an area that displays the data from those trackers.

What I am trying to do is make it so that the data returned from one of my trackers (gas in this instance) is automatically updated in the budget as I update the tracker based on which month it is.

Example:
example date: FEB 21, 2011

BUDGET DATA                                      TRACKER DATA
COL A   COL B                                   COL S        COL T
gas      =Formula                               JAN          200.00
                                                FEB          160.00
                                                MAR          350.00

So, what I want it to do is search COL S (a cell range in COL S to be specific) for the current month and return the corresponding amount from COL T and display that data in COL B.

For instance if the current month is February, I want it to show the 160.00 that is in COL T in COL B. And then when February end, and we enter March it would show the 350.00 only.

That way as I go through the year I don't have to constantly go in and do "=S2" or "=S3" depending on the month, Excel would just update it with the correct data.

I know this might be confusing so please ask questions.

 

[Aladin Akyurek]

Try something like...

=VLOOKUP(TEXT(TODAY(),"mmm"),TrackerTable,2,0)

 

[T. Valko]

Ok, I have been trying to figure this out for about a month now, but I just can't find a formula that will do what I want. I am trying to improve on my budget workbook, make it do a few more things automagically. In my budget workbook, I have 1 sheet for the budget and several others as trackers to be able to track where and how much I am spending in specific categories (i.e. gas, groceries, dining out, etc.). On my budget sheet I have an area that displays the data from those trackers.

What I am trying to do is make it so that the data returned from one of my trackers (gas in this instance) is automatically updated in the budget as I update the tracker based on which month it is.

Example:
example date: FEB 21, 2011

BUDGET DATA                                      TRACKER DATA
COL A   COL B                                   COL S        COL T
gas      =Formula                               JAN          200.00
                                                FEB          160.00
                                                MAR          350.00

So, what I want it to do is search COL S (a cell range in COL S to be specific) for the current month and return the corresponding amount from COL T and display that data in COL B.

For instance if the current month is February, I want it to show the 160.00 that is in COL T in COL B. And then when February end, and we enter March it would show the 350.00 only.

That way as I go through the year I don't have to constantly go in and do "=S2" or "=S3" depending on the month, Excel would just update it with the correct data.

I know this might be confusing so please ask questions.

Try one of these...

A2 = gas

Assuming there will only be one instance of each month in column S.

=SUMIF(S2:S10,TEXT(NOW(),"mmm"),T2:T10)

=INDEX(T2:T10,MATCH(TEXT(NOW(),"mmm"),S2:S10,0))

=VLOOKUP(TEXT(NOW(),"mmm"),S2:T10,2,0)

 

[protocel3]

Try something like...

=VLOOKUP(TEXT(TODAY(),"mmm"),TrackerTable,2,0)

Thanks, I tried a VLOOKUP before but I must have missed something, because it worked this time. Thanks for the speedy reply, this will save me tons of time.

 

[Aladin Akyurek]

Thanks, I tried a VLOOKUP before but I must have missed something, because it worked this time. Thanks for the speedy reply, this will save me tons of time.

You are welcome. I appreciate the feedback.