Still uncertain about the task...

D1:

=IF(ISNUMBER(A1),IF(B1="",LOOKUP(9.99999999999999E +307,C:C),1-ISNUMBER(B1)),"")

amc422 Wrote:[color=blue]
Yes, however it won't always be A1 and B1... the row will advance by at
least
one every day. So it would be A1 and B1 today; A2 and B2 tomorrow;
possibly
A5 and B5 the following day (as more than one row of data could be
added in a
given day).

Also, please note my last post with an additional condition.

Can this be done?

Thanks,
Anna

"Aladin Akyurek" wrote:


If A1 houses a number and B1 is empty, return the last numerical
value
that is in C. Is this what you want?

...


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=278034