|
|
#2
07-28-2014, 08:01 AM
|
|||
|
|||
So if Airport Lighting is selected from the drop down, you want Engineering displayed in an adjacent cell?
If so, that can be done by putting the category next to each subcategory (Engineering to the right of Airport lighting, etc.) and just do a vlookup. You might want to consider, nested dropdowns in which case you would select one of the 5 categories (Housing, Gen'l Building, etc.) which would then populate another dropdown with the subcategories for that category. You can read how to do that here. I have attached an example using your data. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| display text from formula | ketanco | Excel | 1 | 04-24-2014 10:45 AM |
| Converting Q and A to database | jscgdunn | Word | 1 | 04-11-2014 05:29 PM |
| Milestones: Display of - turning off the display of the date | Pmacdaddy | Project | 3 | 01-18-2013 05:42 PM |
 If formula result is negative then display text
|
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
|
little database
|
gsrikanth | Excel | 3 | 06-29-2012 05:23 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode