Sorry, misread your post.

Try this:

=LOOKUP(2,1/(1-ISBLANK(B1:IV1)),B1:IV1)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RagDyeR" wrote in message
...
Try this:

=LOOKUP(2,1/(1-ISBLANK(A2:A1000)),A2:A1000)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CJE" wrote in message
...
I know it is probably the easiest thing to do, but I can't figure it out.
I would like cell A1 to pickup the last entry in row 1, will be nuberical.