Exactly !
Isn't that what was asked for ... in the OP ... and in the subject line?<g

Isn't an error return from a formula just as valid a response as a "1" or an
"A"?
As long as the error is *not* caused by the "checking" formula *itself*!

And of course, the magic word in my suggestion was "try", since the OP is
the final judge as to the functionality and validity of any submitted
suggestion.

BUT, I must admit that you do perhaps have a point, in that it would have
been better practice on my part to "advise" that *all* formula returns,
values as well as errors, will be displayed by my suggestion, as well as
*all* keyed in entries.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Aladin Akyurek" wrote in message
...

Ragdyer wrote:
You could try this for *either* text or numbers:

=LOOKUP(2,1/(1-ISBLANK(C5:C10)),C5:C10)


That means: Return any last entry from C5:C10.