View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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)])