Need Help..
 

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?

Need Help..
 

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



"Ryan''s Girl" wrote:

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?

Need Help..
 

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.

"CLR" wrote:

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



"Ryan''s Girl" wrote:

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?

Need Help..
 

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

"Ryan''s Girl" wrote:

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.

"CLR" wrote:

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



"Ryan''s Girl" wrote:

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?

Need Help..
 

Thanks that's what I was looking for!!

"CLR" wrote:

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

"Ryan''s Girl" wrote:

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.

"CLR" wrote:

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



"Ryan''s Girl" wrote:

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?

Need Help..
 

Happy to help.............thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3



"Ryan''s Girl" wrote:

Thanks that's what I was looking for!!

"CLR" wrote:

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

"Ryan''s Girl" wrote:

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.

"CLR" wrote:

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



"Ryan''s Girl" wrote:

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?