Wednesday, December 28, 2011

yogi_Expense Register With The Name Of Statement Period As A Variable

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user LMLML said:
get text from one cell into the formula of another cell
I have a formula in my check ledger spreadsheet which looks for the last balance value on the previous sheet, and inputs it as a "previous balance" on the new sheet
the formula takes the name of the previous sheet as an input in 4 places, and I would like to be able just to enter the name in its own cell, and have the formula grab it 4 times, rather than me copy/pasting it in 4 times
the fomula looks like this:
=FILTER( 'nov-dec'!H4:H1000 ; ROW('nov-dec'!H4:H1000) =MAX( FILTER( ROW('nov-dec'!H4:H1000) ; NOT(ISBLANK('nov-dec'!H4:H1000)))))
so I would like to have 'nov-dec' in its own cell, and a variable in the above formula instead... is that possible??
following is a solution to the problem