I am trying to return a value to a cell based on specified conditions in a
range that increases every day by one or more rows. I want return the value
of a cell which will positionally change daily (but will always be in the
same column) as new data is entered (and likely be the last cell of the
active spreadsheet) to another cell which will remain constant.

To illustrate:

Column A Column B Column C
Row 1

Row 2
Row3
Row4
Ect...

I know I need to use conditional logic, but can't get the syntax. I want
the value in Column C returned to another defined cell if the following
conditions are met:

There is numerical data in column A
AND
There is no data in column B

But here's the rub (for me): it must be the value of the last "active" cell
in column C which meets the specified conditions. Since a new row(s) of data
is entered to the spreadsheet on a daily basis, the row of the last active
cell is is always advancing.

Hope this makes sense.

Can someone please help me?

Thanks in advance,
Anna