I believe i need to write a if then clause.

What i am trying to do is pretty simple in access, but in excel - i've
been at it for days.

Cells A3 to A10 always hold data. In cells D3 to D10 only one cell
holds data, which is a number "1", the other cells are null.


What i am trying to do is:
If cell D4 = 1 then fill cell D12 with the value of cell A4, likewise
if cell D7 = 1 then fill cell D12 with the value of cell A7.

How do i do this and where would i pop the code?

Just new to excel - but making good progress.


---
Message posted from http://www.ExcelForum.com/