I am trying to have a formula with the following datas:
IF C2 equal "Blue"; Sheet1!G3; and make A1=D2.
I typed the formula like this: IF(C2="Blue";Sheet1!G3);AND(A1=D2)
What I need is to have two results with just one command, that means, when I
type Blue on C2, G3 will mark Blue and the content of cell A1 should be
transported to the blank cell D2
I get FALSE, because instead to MAKE, the formula is reading as if A1 is
equal to D2, and my goal is to transport the content of the cell A1 to the
blank cell D2.
I would thank very much to whom will help me.
Thanks in advancing.
Tadu

--
Tadu