Try this:

I'm assuming that "value" means number.

=LOOKUP(10^10,A1:T1)

Biff

"mlh97" wrote in message
...
is there a function that will return the first non-zero cell in a given
range?

For example, I have a range of 20 cells in a row (say column A through
column T), and I want the function (or seried of functions) to look within
the range and return the value furthest to the right. Like, in row 1, the
first value is in column C. In row 2, the first value may be in column F.
In
row 3, the first value may be in column S.

Thanks for the help.