Creating a product selector

[anhandrew]

Hi I have a fairly complication task.

I have a list in excel that I want to create a product selector from.

IE the list is like below

Size type body internal material
1 ehf 316 316 1234
2 eht 316 302 2345
3 ehf 302 bronze 3456
3 ehf 302 alum 4567

So i want to be able to create a list to select size, type, body and internal then it gives me the material.

Please let me know if this is posible in excel. I have spent 4 hours looking up information to do this and have gone no where with it.

Thanks,

Andrew

 

[AlphaFrog]

Have you considered using the AutoFilter feature?

 

[anhandrew]

Yes I have but I need it to be more robust as I will additional part on there. Also I want to make it simple so that I can send it out and other people can just use drop downs to figure
out the end item. Using auto filters will start with a hugh list list and it will intimidate my sales guys.

 

[Nalani]

Sounds like you need Dependent Lists. Check this out:

http://www.contextures.com/xldataval02.html

There is a downloadable example file towards the end to give you a clue.

 

[AlphaFrog]

...but I need it to be more robust .

Please explain.

Using auto filters will start with a hugh list list

How would another method start with a smaller list? Perhaps you could have another column that categorizes the items into subcategories 1st.

Also, Autofilter creates dependent lists.

 

[Nalani]

Well, after rereading your orginal post and rethinking, I have to agree with AlphaFrog. Filtering would be the easiest.

The link I posted will do the same thing. But there is alot of Set-up on your part to make it work.

Your choice > Simple or Fancy.

 

[anhandrew]

Robust as I would like to link publish it to my site so my sales guys have access to it. So down the lines understanding I might do the same to a website.

I don't mid the challege as it is the way to learn. I have happy to say everythin I have learn in excel has been poking at it and learning from examples online.

My list is about 1500 end part numbers. But has the ability to grow 10 times or more.

Thanks andrew

 

[snoopyhr]

Not sure if this is what you want but mabe will get you started in some direction... .

Excel Workbook
	A	B	C	D	E	F
13	Size	type	body	internal	material	Combined
14	1	ehf	316	316	1234	1-ehf-316-316
15	2	eht	316	302	2345	2-eht-316-302
16	3	ehf	302	bronze	3456	3-ehf-302-bronze
17	3	ehf	302	alum	4567	3-ehf-302-alum
18	*	*	*	*	*	*
19	*	Validation	Material	*	*	*
20	*	2-eht-316-302	2345	*	*	*
Sheet1

#VALUE!