Creating a Product Selector

[cirazrael]

Hello,

I'm attempting to create a product selector for work, but finding myself to be completely in over my head. Basically, on the first sheet, I want a simple selector tool with dropdowns for the values in the cells. I'd like it to refer to the information on the second sheet, and parse that information to spit out an answer in at the bottom of the first sheet.

Unfortunately, I have absolutely no idea how to go about this. Any help would be greatly appreciated.

Product Selector.xlsx

[MarvinP]

Hi cirazrael and welcome to the forum,

Excel has these great things called Auto Filters. They work on a table. I've taken your sheet2 data and copy and pasted it using Transpose. Then created an auto filter on it. If you click on the table head dropdowns you can filter any way you want. I think this is what you are really looking for. See the attached.

[sktneer]

Not sure about how you want to do it, please find the attached sheet to see if this is what you want.

[cirazrael]

Hey guys, thanks for all the help.

sktneer - that's ALMOST what I'm trying to do, but I'm actually going for the inverse of that. Basically, I want to be able to select the other fields by dropdown (ethernet ports, PoE ports, etc) and have Excel spit the product name that matches at me in a field at the bottom. Is that possible? How would I go about it?

Thanks

[oeldere]

Or with VBA.

you can push the button to refresh the data.

You can make an pivot table of the data.

[Xx7]

Hello,

I've created a worksheet that will update the "Switch" result C11 when the values are change in C2:C9

I've also included dropdown lists for cells C2:C9.

Please Login or Register  to view this content.

[cirazrael]

Xx7 - This is exactly what I was going for! Thank you so much!

If it's not too much trouble, could you tell me step-by-step what you did so I'll be able to do similar things myself in the future?

Thank you!

[Xx7]

For the dropdown lists, go to each cell. Select "Data", "Data Validation"... under "Allow:" select "List".. enter the amounts you want in the dropdown (eg. "1,4,8,12"). See image attached.

[cirazrael]

Thanks for that. What did you do to get it to spit out the correct data? I see the code you entered - but how did you go about entering it? I apologize if this is a ridiculously simplistic question - but my Excel-Fu is clearly weak.

[Macpic]

Xx7, the product selector is brilliant. However, I'm trying to make it so that not all the cells have to be filled in for it to give a result. I shere a way that it can give a result basis only filled in information ? My second question is as follows : what if there are multiple results ? can the selector show more than one result at a time (I admit this is in the case that not all the celles are filled in).
Many thanks in advance for your response.

[samonlinesuper]

Hi Xx7,

How to have the multiple result retirn.

[jeffreybrown]

Unfortunately your post does not comply with Rule 4 of our Forum RULES.

Please do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.