Excel: autofill cell depending on text in another cell

hello all, the noob is back for help if possible. I have a cell (A13)that is populated by drop down list. the text reads for alternative treatment if cell A13 has the word alternative in it I would like cell E13 to autofill with the numbers 180103* if that is possible hope that makes sense regards acehole

This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of May 29, 2014.

For more resources for Microsoft Excel