Building a Form

[Henry]

Hi: This is new to me so bear with me.

I was originally using a .doc to create a Template Form, but the .doc template is not easy to use with calculations, so it was suggested I use an Excel .xlt. So.......

I've created a Drop Down List (DDL) of 50 Names. You see this on the .xlt.
I've also used the Index Function translate the DDL choice to replace the DDL number with the corresponding choice. This result is in a separate cell. The problem is, when you look at the Form, you see both the DDL choice as well as the result from using the Index.
I'm trying to set this up so that when you select from the DDL, that result can be used in Calculations, such as price x quantity.
I only want the result to show; therefore, cleaning up the Form. I looked an Excel Book but there form is really cluttered.

Did I confuse you? Suggestions!!!!!!!

MT

 

[Anne Troy]

MT: Forget the control toolbox dropdown. Sounds more like you only need data validation. Check it out, hope it helps!

http://www.theofficeexperts.com/excel.htm#DropdownLists

 

[Yogi Anand]

Hi Henry:

In addition to valuable suggestion by Anne(Dreamboat), I suggest you post your sample data that you have to work with, and then let us look at which of the Excel features, such as Data Validation, INDEX, MATCH, VLOOKUP, ... can be best utilized for your situation.

Regards!
Yogi Anand