dependent dropdown

  1. L

    Excel Dependent Drop Down Error

    I am creating a dependent drop down where the drop down itself is located on the first tab of the sheet and the data that includes the dropdown options is on another tab. When the drop down and the data are on different tabs, I get the following error when entering the index match function into...
  2. J

    Three-Tiered Dependent Dropdown

    Good Day Everyone, I am a relative novice with Excel and I am looking for some help and advice in creating a three-tiered dependent dropdown in Excel 365. Over the last few days I have searched Google and YouTube extensively but have so far been unable to find what I'm looking for :( A friend...
  3. L

    VLookup + Match functions for two column lookup with multiple words

    Hello, I am attempting to create a sales quote creator. I have a product database in one sheet with product number, product, product options, and price in each column. I then have the 'sales quote creator' in another sheet with a dependent dropdown list (with product options being dependent on...
  4. P

    Dependent Dropdown lists within a table?

    Message Board, I am trying to create several dependent dropdown lists within an excel table. However all the tips/tricks that I have been able to find on this subject only refer to creating dependent dropdown lists in cells not incorporated into a table. For example, I would like to achieve...
    • PQK
    • Thread
    • data validation dependent dropdown dependent list table
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top