On Fri, 24 Sep 2004 03:04:42 -0400, "Yogi_Bear_79"
wrote:

I would like to set a cell todisplay the value from another cell on a
differant sheet, in the same workbook. I need it to look in a column range
from F2:F14. It should select the data from the last cell used that does'nt
contain a zero. I know how to do a basic IF statement, but not sure how the
syntax would work on this one. I would prefer to keep this one a formula
versus a VBA macro


With your range named "rg", this *array-formula* will work:

=INDEX(rg,MAX((rg0)*ROW(rg))-ROW(rg)+1)

To enter an *array-formula*, after typing or pasting it into the formula bar,
hold down <ctrl<shift while hitting <enter. XL will place braces {...}
around the formula.

Note that it is not necessary to NAME rg. I wrote it that way so the formula
can be more easily generalized to other ranges.


--ron