Need Help..

  • Thread starter Thread starter Ryan''s Girl
  • Start date Start date
R

Ryan''s Girl

The heading of one of my columns is named "Notes" my question is for
inserting data into this column. I would like to type "EXPORT" I want Excel
to recognize this word and insert a sentence into a different column. Can I
do this?
 
Assuming your Notes column is A.....
put this formula in the cell where you want the new sentence.

=If(A2="EXPORT","Put this sentence in this cell","")

Vaya con Dios,
Chuck, CABGx3
 
Maybe I should be a little more clear...
Date(A) Job Number(B) Notes(C) Skid Size(D) Notes(E)
I enter row after row of information in this spreedsheet. If in column C Row
1 (Notes) I enter "EXPORT" .....I would like Column E Row 1 (Notes) to
automatically insert "JAD INFO"
The formula you gave me was not exactly what I was looking for.
 
If, when you place a value of "EXPORT" in cell C1 and you want the value "JAD
INFO" to appear in cell E1, then put this formula in cell E1, and copy down
as/if desired.

=IF(C1="EXPORT","JAD INFO","")



Vaya con Dios,
Chuck, CABGx3
 
Thanks that's what I was looking for!!

CLR said:
If, when you place a value of "EXPORT" in cell C1 and you want the value "JAD
INFO" to appear in cell E1, then put this formula in cell E1, and copy down
as/if desired.

=IF(C1="EXPORT","JAD INFO","")



Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Back
Top