+ Reply to Thread
Results 1 to 3 of 3

Need Dependent Cell validation list

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Charleston, SC
    MS-Off Ver
    Excel 2010
    Posts
    75

    Need Dependent Cell validation list

    I am trying to develop a professional services matrix where i have the services identified and a base level of effort assigned. I then have separate lists for the LOE levels and hours that would apply for each LOE. What I want is when you select the service offering, it will populate the Level of Effort column automatically and let you choose from the drop down the hours assigned to that LOE. I know this is pretty simple but my brain is fried now at the end of the week,. See attached file.

    Thanks,

    Hank
    Attached Files Attached Files
    Last edited by hmr2662; 02-15-2019 at 07:22 PM.

  2. #2
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: Need Dependent Cell validation list

    In B3 you just need a standard lookup formula (VLOOKUP or INDEX/MATCH), then in C3 the validation settings source you can use an INDIRECT function and just join "LOE_" to (the value in) C3.

    Please Login or Register  to view this content.
    If you convert your lists back into ranges from a Table the lookup formula may be easier to understand.

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Charleston, SC
    MS-Off Ver
    Excel 2010
    Posts
    75

    Smile Re: Need Dependent Cell validation list

    Thanks Echo Passenger. That worked. I also added an iferror statement so column B would show blank if no entries in column A.

+ 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. Replies: 1
    Last Post: 01-03-2019, 08:09 PM
  2. Nested validation list dependent on cell value
    By Eline in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 06:33 AM
  3. Replies: 18
    Last Post: 09-18-2013, 10:29 AM
  4. Validation list (dependent on the result of the preceding list) + Concatenate
    By Elainefish in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-08-2013, 09:19 AM
  5. Data Validation List - Dependent on Adjacent Cell - Value from Unsorted List
    By justforthis1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-26-2013, 12:24 PM
  6. Replies: 2
    Last Post: 07-17-2012, 01:18 PM
  7. Replies: 2
    Last Post: 05-12-2011, 09:23 PM

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