Dependant Lists in Excel

  • Thread starter Thread starter Browett
  • Start date Start date
B

Browett

Hello,

I am trying to create a worksheet with many drop down lists tha
coincide with each other. I would like to have it where I have
machine drop down list, after selecting your machine, it will the
select the proper list of attachments to match with the machine. Wit
the attachment selection, I would need multiple lists to run from it.

Example, the machine selected, and a list of attacments would show
From there I would like to select all 4 attachments, each attachmen
would be selected from a drop down list. Then from each the machine
and the attachments, I would like a price to show up in anothe
column.

Machine
Wheel Loader $150,000
Attachments
quick coupler $4000
fork rack $8000
bucket $12000
grapple $17000

Any ideas?

Th
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
dependent drop down list 1
Excel Lists 4
sizing in Drop Down lists 6
Excel Excel: How do I put a formula in a drop down list 11
Formatted cell column in drop down list 1
Excel -- Data Validation -- Create Dependent Lists 6
Data Validation - Conditional List 3

Back
Top