|
|
#2
01-06-2015, 07:03 AM
|
|||
|
|||
This should work for you. I have attached a sample of what I worked up. The top left table is your list of Vendors. It's easiest if you keep them to one word, but the link shows a work around.
To the right are the lists of tools from each vendor. Below that is the data validation. There's a drop down for Vendor. Once a vendor is specified, the dropdown for that vendor's tools is enabled. See if that will get you started and let me know if you need further help. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Validation Issue in Excel | rrparekh | Excel | 0 | 10-27-2014 10:53 AM |
 data validation from another sheet
|
paulys | Excel | 1 | 06-30-2014 01:40 AM |
|
Data Validation drop down
|
rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
|
Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode