I am working on a spreadsheet that list a number of packages available.
Each package has a name and 3 to 6 cells under it listing what is in that
package.
For instance: FAX MACHINE PACKAGE is the 1st cell and under it is Fax
Machine, power cord and RJ Cable each in their own cell

I have already created a dropdown box so the packages can be listed and
chosen that way but what I need to figure out is how to get excel to take
that drop down information(package name) and show me what is in the package.

I am using all of this in an email to order items. The person selects what
package they need and a box populates with the contents (so they can edit out
what they dont need)

Any of that make any sense at all or am I hopelessly confusing myself?

--


``DAThomas``