Results 1 to 2 of 2

Thread: Data validation - using Two word w/ dependent.

  1. #1

    Data validation - using Two word w/ dependent.

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello - I have created a spreadsheet that has two columns that have a data validation dependent drop down. I need to modify the first column by it being a two word option ( First and Last name) how do I add this without disturbing the dependency of the second column?

    To be more precise- See my attachment:
    This shared spreadsheet is being accessed by Inside Sales reps they are to input appointments they have set for their perspective Regional Managers. In the Source tab I have added the Last name to the "Inside Rep" then if you select the January tab- Column F is the "IS Rep" that will show their name and when that selection is made their Regional MGR's should appear in the Regional MGR's column. I have created a data validation with dependent formula for this by using the ISR Rep's first name. For reporting purposes we now need to have first and last name appear in the ISR Rep column in the data validation. What formula or function do I use and where? I have already added in my source tab the last names. I cant seem to correlate that with their Regional MGR- data validation. Please take a look at my attachment. Where have I gone wrong?! Any help or advice is greatly appreciated!

    Thank you!!
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Duplicate thread

Posting Permissions

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