Results 1 to 7 of 7

Dependent Drop-down menu without named ranges

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-15-2009
    Location
    Broooklyn, NY
    MS-Off Ver
    Excel 2016
    Posts
    207

    Dependent Drop-down menu without named ranges

    I have fruits. vegetables, meat, poultry and seafood. I already have a drop-down for that in the cell B8. Now I need to select a product based on the category. I tried Index and Match before but I get an error. I don't want to do it with named ranges so it has to be the formula. Hopefully, you can help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cell value dependent on a drop down menu
    By Ray522 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2019, 12:11 PM
  2. Dependent drop down lists -- without named ranges?
    By vicken_a in forum Excel General
    Replies: 3
    Last Post: 03-30-2018, 12:52 PM
  3. Drop Down Menu Dependent On Another Cell
    By bwils39 in forum Excel General
    Replies: 2
    Last Post: 03-30-2017, 12:15 AM
  4. Help requested on dependent drop down menu
    By jun-xin.chen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2015, 06:03 PM
  5. Named Ranges Dependent On Cell Value
    By tlscowden in forum Excel General
    Replies: 1
    Last Post: 06-19-2015, 07:44 PM
  6. [SOLVED] Creating thousands of Named Ranges for Dependent Validation
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2015, 12:43 PM
  7. [SOLVED] Dependent data validation with dynamic named ranges
    By Ace_XL in forum Excel General
    Replies: 4
    Last Post: 08-07-2014, 10:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1