Fast Solution to Error: Dropdown List with conditions

Dropdown List with conditions

Need a little help from anyone, here is the situation.

I have a data validation drop-down list in row "A" then each item on the list have sub-categories like for "A" I have A1-1,A1-2,A1-2, etc.
I want my Row B drop-down list to be according to the data in Row A. 

For example:
Row A list Items are Vegetables, Meat, Fruits
Vegetable sub-categories are Straw beans, Coriander, Pepper etc.
Meat sub-categories are Pork, Beef, Chicken etc.
Fruits sub-categories are Banana, Apple, Grapes etc.

If A1 is "Vegetable" the dropdown list on "B1" should be straw beans, coriander, pepper etc.

I hope my explanation was clear.

Thanks in advance


Anwsers to the Problem Dropdown List with conditions

Download Error Fixer for Free Now

To check for Windows updates

  1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  3. If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Recommended Method to Fix the Problem: Dropdown List with conditions:

How to Fix Dropdown List with conditions with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Related: Cant Delete E-mail Junk From Inbox,Cant Download Itunes Using Windows Vista 32 Bit,CKEditor Showing Up Blank In New Installation Of Internet Explorer 9,Cant Save Anything,Cant Install Windows Live Essentials Error: 0x80190194: WaitForCatalog,Computer Experiences A Black Screen And Then An Un Ending Loop Of Repairs,Computer Start Up Problem - Won't Allow Me To Open Programs Until I See The Network Connected,Computer Won't Boot - Tried Windows 7 Recovery Sats Missing Operating System Its A Compaq Cq56 Laptop,Computer Hangs At Logon,Conditional Formatting In Excel - Highlighting Date Specific Cells,Delete First Link In Excel,Dead Pages And Vanishing Cursor,Dell Wireless Wlan Card Wireless Network Controller Stopped Working,Desktop Icons Change Location At Every Boot.,Determine If Cell Is Selected,Diet Herbs: Chickweed, Cinnamon, Citrus Aurantium - Synephrine And Cordyceps,Facts About Collecting Vintage Swords,The Irritable Bowel Treatment Diet,The Best Of American Muscle Cars,Ebay Auction Tips
Read More: Troubleshooter of Error: Display fading after booting up on desktop pc,Does Windows backup automatically create images? [Solved],Driver Bluetooth LWFT device - Says that I have got a problem with my Bluetooth LWFT device drive. [Solved],Disk light comes on hard, sound loops and get BSOD with KERNEL_INPAGE_DATA_ERROR when playing games on HP DV7 notebook [Solved],Troubleshoot:Download Internet Explorer 7 for Vista,Cut and paste feature not working in Windows 7,Custom label definition ignored,Dashboard help - summing and ranking items,Dozens of Windows keep opening,Disk Cleanup utility
by HowToRemoveAbo | 2016-09-30 09:51