Change from what to what?

Or just a change?

A1 contains the word "hoohah"

In A2 enter =IF(A1="hoohah","T","A")

Or did you have something more generic in mind?

On any change at all you would need event code to update A2 rather than
having a fixed formula as above.

Post back if that's the case.

BTW..............Excel syntax for cell references is Column/Row

A1, A2, B1 etc.

Get used to using that syntax rather than Cell_1 or Cell_2


Gord Dibben MS Excel MVP


On Wed, 8 Apr 2009 16:02:01 -0700, JJ wrote:

I have 2 columns, if i change cell_1 in column_1, my cell_2 is going to
change the text from "T" to "A".

how can i do this?