Results 1 to 6 of 6

Validtion list varying based on data on another cell

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Validtion list varying based on data on another cell

    Hi,

    I have a validation list to be created on column C where only the list related to the value in Column B should be available to select from drop down list along with 1 default value 'UNKNOWN" in all drop down lists.
    As provided in the attached sheet, I have the actual data in Sheet1 and the list mapping in Sheet List. I Have provided only few of the records in Sheet "List" where there are 100 of records in my actual data.
    SO when the value under Item in Cell B2 is "Can", I should have the list related to value "Can" from Sheet "List" available in drop-down along with the value "UNKNOWN".
    The drop down list on Column C should be like below and I can select one form the list
    Tin
    Steel
    Opener
    Lid
    UNKNOWN

    Can anyone please let me know the steps to achieve this using the formulaes.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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