Multiple drop-down list selections and HLOOKUP multiple results in the same cell

I'm not sure if this is the correct forum to ask this question or if I should have posted it in the VBA forum but here goes...

Product Name:	Product Type 1:	Product Type 2:	Product Version 1:	Product Version 2:	Product Version 3:	Product Version 4:
Alpha	Electronics		Free Trial	Basic	Deluxe	Business
Beta	Electronics	Retail	Free Trial	Basic
Gamnma	Electronics	Commercial	Free Trial	Basic
Delta	Hardware			Basic	Deluxe	Business
Omega	Hardware	Retail		Basic	Deluxe	Business
Zeta	Hardware	Commercial		Basic	Deluxe

Let's say I have the above table and I want to create a product selection form, with drop down menus, which would have the following options:

Select your product: (this would be a drop-down menu, with a list of products from Column 1 - Product Name).
Product Type(s): (this should be auto-filled, with no user interaction, by the choice from "Select your product", but should return the values from both Product Type 1 and Product Type 2 columns, in the same cell, separated by comma)
Select your version: (this, again, should be a drop-down menu, with a list of product versions from Columns 4-7, but it should only show the options pertinent to the product chosen in "Select your product").

Would this need to be done with VBA code or can I use HLOOKUP or another formula to get the results I want?

Thanks!

PS: I have also now asked this question on the ozgrid.com forums (http://www.ozgrid.com/forum/showthread.php?t=205189) hopefully to get some more ideas about how to deal with the number of products.

What's the maximum number of product versions?

Have a look at this: http://www.contextures.com/xlDataVal02.html

This is a very basic version of what I think that you want. It can be tweaked considerably, if it IS what you need.

What mmight be a pain would be setting it up for a large number of PRODUCTS, non product verssions, as each Product needs its own Data Validation column.

UNLESS... you only want this dropdown to be applied on a small number of rows.

How many products?

How many rows (MAXIMUM)?

This is what I was looking for but the number of products will end up being considerable (over 50) and I'm guessing it would make this clunky.
Also, for some reason, when I tested your file, selecting "Gamma" as a product results in an empty drop-down menu for "Options", and when I tried to do a Data Validation it said that there was an error. At the same time, the Description column was populated correctly.

All the other Products worked correctly.

Fixed. Neither of us spelled gamma correctly!! At least I have an excuse....

So to my second question: how many rows (maximum) will you need this set-up on?

OK. That blows Plan B out of the water....

So. It'll be fiddly to set up, but multiple named ranges will work for you.