importing excel forms to adobe and associatied problems

Fields and equations/calculations are not carried over when converting from Excel (or any other Office format) to PDF. They have to be re-created in the PDF from scratch.

To populate a text field from a drop-down selection you need to use a script. This is the basic code (to be used as the custom Validation script of the drop-down field):

if (event.value=="Option 1") {
	this.getField("Text1").value = "Some text for Text1";
	this.getField("Text2").value = "Other text for Text2";
} else if (event.value=="Option 2") {
	this.getField("Text1").value = "Some other text for Text1";
	this.getField("Text2").value = "Other other text for Text2";
} else {
	this.getField("Text1").value = "";
	this.getField("Text2").value = "";
}

Adjust the field names and values in the code as needed, of course.