Results 1 to 3 of 3

Dependent drop downs

Threaded View

  1. #1
    Registered User
    Join Date
    11-18-2015
    Location
    Phoenix, AZ
    MS-Off Ver
    2016
    Posts
    18

    Dependent drop downs

    Hello,
    I'm using Office 2016 and I've already set up the attached sheet so that you select the carrier and the audit type from drop downs and that works well. Now I want to add the auditor's extension and shift hours which are located on the tab called drop downs. Im having a tough time figuring out how to make it work.

    I've tried these two equations without success

    IF(OR(F6="Allen", "227/127, f6="Bud", "235/135", f6="Chris", "147", f6="Doug", "237/137", f6="Maria", "232/132", f6="Mike", "108", f6="Shaun", "234/134", f6="Steve", "212/112", f6="Alfonse", "202/102", ""))
    or
    IF(F6="Allen", "227/127, f6="Bud", "235/135", f6="Chris", "147", f6="Doug", "237/137", f6="Maria", "232/132", f6="Mike", "108", f6="Shaun", "234/134", f6="Steve", "212/112", f6="Alfonse", "202/102", "")

    I am fine with either pulling the data from the drop down tab or just entering it as strings as above. Can anyone help? Thank you in advance
    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. Variable Dependent Drop Downs
    By aeroslinger in forum Excel General
    Replies: 5
    Last Post: 10-09-2014, 05:45 PM
  2. multiple dynamic dependent drop downs
    By atomicrabbit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2014, 10:54 PM
  3. [SOLVED] Dependent Drop-Downs (Indexed)
    By BobBing in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2012, 05:33 PM
  4. [SOLVED] How to Reset Dependent drop downs
    By ertweety in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2012, 06:10 PM
  5. Creating dependent drop downs
    By harrybelly in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:08 PM
  6. Dependent Drop-Downs
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:06 PM
  7. Dependent drop downs.
    By Mattypb in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-16-2009, 08:47 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