I have designed an order form using excel 2010 and wanted to know if I have used data validation in a cell to list my product type is it possible to have the material type only offer the materials available based on the selection made in the product type cell?
Yeah it is possible..
Index Match will do..
will be better if you provide a workbook...
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
That's called Dependant Lists... check out this tuturial: http://www.contextures.com/xlDataVal02.html
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Here is a simple example of dependent lists:
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Data Validation Order Form.xlsx I'm a newbie so I hope I attached it properly?
Can you tell us what exactly the expectations are? What materials do you want to appear for each specific product?
Thank you so much, I did it!!!
How do I mark this solved?
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks