+ Reply to Thread
Results 1 to 4 of 4

Need Help! Drop Down Menu

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Riyadh
    MS-Off Ver
    2013
    Posts
    12

    Need Help! Drop Down Menu

    Hi,

    I am New to Excel, can somebody help me with the formula for drop down list.

    test.png

    Eg : 1. Executive (Drop down menu) 2. Domestic (drop down menu) 1000 (based on 1 & 2 Table selection)
    Last edited by Nushan; 12-25-2018 at 05:09 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need Help! Drop Down Menu

    Selam

    Select the cell that you want the drop down for the trip type

    Select the Data Tab and then Data Validation.

    In the Allow Box select List

    Select "Ignore Blank"

    Select "In Cell Dropdown"

    In the List box enter "Domestic, Asia, ROW"

    **********************************************************************

    Select the cell that you want the drop down for the Personnel type

    Select the Data Tab and then Data Validation.

    In the Allow Box select List

    Select "Ignore Blank"

    Select "In Cell Dropdown"

    In the List box enter "Executive, Manager, Staff"


    In the box where you want your result enter this formula

    =IF(OR(A10="",C10=""),"",OFFSET(A1,MATCH(A10,A1:A7,0)-1,MATCH(C10,A1:D1,0)-1))
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    05-08-2018
    Location
    Riyadh
    MS-Off Ver
    2013
    Posts
    12

    Re: Need Help! Drop Down Menu

    Thank you very much for the help...

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Need Help! Drop Down Menu

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How a drop down menu's list can change depending on another dropdown menu.
    By sudeepkm73 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-30-2015, 03:18 AM
  2. Resetting a drop down menu by selecting another drop down menu
    By Chris07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2013, 11:57 AM
  3. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  4. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  5. Replies: 0
    Last Post: 06-25-2012, 03:22 PM
  6. Replies: 2
    Last Post: 01-30-2009, 04:23 PM
  7. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 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