How can one set a value TO another cell?
An Excel function can't put a value in another cell; it just returns a value
to the cell that contains the formula. I think the following array formula in
D1 will do what you want:
=INDIRECT(ADDRESS(MATCH(1,IF(B1:B2000100,1,0),0), 1))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do
it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
Hope this helps,
Hutch
"blixel" wrote:
On Jun 20, 10:52 am, Stefania
wrote:
Hi blixel,
If you're using colum C to calculate data, then write the followingformula
in column D and copy it down:
=IF(B1100,A1)
Thanks but that won't work in this case unless I want to have over
2,000 nested IF statements in cell D1.
IF(B1100,A1,IF(B2100,A2,IF(B3100,A3))) (And so on * thousands)
What I need is for the formula in column C to "push" the date to D1.
(IF[calculations are true],[SET.D1(A1)])
|