Looking to create order form; not sure what to search

[emsterv]

Hi there! I'm looking to create an Excel order form. I know only the very basis of Excel but learn quickly/follow tutorials well.

I'm trying to create an order form where I can enter (in one cell - "Package(s)") a list of ordered items named "A" through "T". Then I would like the spread sheet to a) list the descriptions of the items ordered - which you can see in purple font and red font in the picture. Colour differentiation is not necessary and just for explanatory purposes. And b) add up the total cost of the items ("Total" column).

I'm sure the information that I'm looking for is readily accessible, but I'm not sure what terminology to use to search for my answer. Hopefully someone here can either let me know steps to create the form OR the terms to search by so I can find the info myself.

Thank you!

Untitled-1.jpg

[emsterv]

I should note that I'm not adverse to creating 3 or 4 separate columns for packages ordered and their respective package details however I do need to make labels using this information afterwards and I don't want to have blank columns appearing on the mail merge as "Packages A, B, , , " when someone only orders 2 packages. There is usually a max of 4 packages ordered per person.

[Chris McGlothen]

You need to create a table with all of your details on a separate sheet. Then you need to do some data validation (drop down) boxes that would allow you to choose packages in Column C. Column D would do a Vlookup to pull the description. Column E would be the total. If you attach a Spreadsheet it would be easier to paste formulas and give you an example of a table that will benefit you in this task.

[emsterv]

Hi Chris, thanks for your reply! I'm unable to attach the excel to my reply - possibly a post minimum before I can do this?

Here is a link to the file in my dropbox. Any help is appreciated