Is it possible for cell formula to assign a value to another cell?

[foolios]

I was hoping that in the IF statement of cell B4 that I could check for a value in cell A2. If that value was true, then assign a value to a different cell. But instead the cell that the function is in(B4) displays the value FALSE after I hit return upon placing this formula in it.

=IF(A2=1,Sheet2!$A$3="G","Not A Match")

Is it not possible to change the value of another cell with just a formula from the cell the formula is within?

 

[shg]

Formulas in Excel can only return a value to the cell in which they appear.

 

[foolios]

Thank you for clearing that up.