It would indeed! Those apostrophe's are very fiddly, for future reference
try Unit_Values instead, then the dreaded apostrophe's are unnecessary. Glad
you have a resolution though. Very good advice from you on this too David,
thanks,
Regards,
Alan.
"Jean" wrote in message
...
It works!!! (I left out an apostrophe...it would have been easier if my
sheet names didn't have spaces!)

Thanks again.
Jean

"Alan" wrote:

Sorry, that one was wrong, try
=INDIRECT("'Unit Values'!D"&MATCH(9.9999999E+306,'Unit
Values'!D:D))/INDIRECT("'Unit Values'!D"&MATCH(9.9999999E+306,'Unit
Values'!D:D)-1)-1
All one line,
Regards,
Alan.
"Jean" wrote in message
...
Thank you very much...I thought this might work, but I ended up with
100.486%. How would I use this in my current formula of:
=('Unit Values'!D$79/'Unit Values'!D$78)-1

"Alan" wrote:

This will divide the last cell in column D with a value in it by the
cell
immediately above it,
=LOOKUP(2,1/(Sheet1!D1:D1000),Sheet1!D1:D1000)/(LOOKUP(2,1/(Sheet1!D1:D1000),Sheet1!D1:D1000)-1)
Regards,
Alan.
"Jean" wrote in message
...
I have a formula that looks like this:
=('Unit Values'!D$79/'Unit Values'!D$78)-1
The D$79 is referencing the last row of the 'Unit Values' sheet.
Every
month I have to add another row of information in the 'Unit Values'
spreadsheet. This means that I have to edit all my formulas to read
D$80.
The following month, I have to edit the formula to read D$81. This
is
always
referencing the last row of data. There are no blank cells in
column
D.
Is
there a function that I could add to the above formula that will
always
reference the last cell in that column? Thanks!