Reference end of month balance on previous workshhet

J

John Richards

I want to dedicate a separate worksheet for each month for a period of
several months showing daily adjustments to a beginning daily balance based
on a variable multiplication factor to produce an ending daily balance. My
problem is that the ending balance for the previous month could be in any
one of four cells (rows)depending on how many days in the previous month (28
to 31 days). For each new month, I would like to retrieve the ending
balance for the previous month by referring to the cell (row) that
corresponds to the last day of that month regardless of what actual row it
is in. It wouldn't be a major problem to manually enter the beginning
balance for each new month but if there is a simple formula that could be
copied to all the sheets I would prefer that option. Thanks in advance for
any help.

John
 
D

Don Guillett

try a match of a number larger than possible such as

=INDEX(Sheet1!A:A,MATCH(999999999,Sheet1!A:A))
or even
=max(sheet1!a:a)
 
H

Harlan Grove

Don Guillett wrote...
try a match of a number larger than possible such as

=INDEX(Sheet1!A:A,MATCH(999999999,Sheet1!A:A))
or even
=max(sheet1!a:a)
Click to expand...
....

=MIN(Sheet1!A:A) is as likely to be correct as =MAX(Sheet1!A:A), so
better for the OP to stick with the first formula. Or, if there were
headings in rows 1 to 4, this could be simplified to

=LOOKUP(1E300,Sheet1!A5:A65536)
 
Top