Results 1 to 6 of 6

If Statement with data validation based on a letter

Threaded View

  1. #1
    Forum Contributor dagindi's Avatar
    Join Date
    06-02-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    295

    If Statement with data validation based on a letter

    I am trying to put an if statement into data validation based on the following:

    C5 has a name range list, "List1" consisting of:

    DILN
    DILC
    DILG
    DIMN
    DIMC
    DIMG
    DIHN
    DIHC
    DIHG
    NJLN
    NJLC
    NJLG
    NJMN
    NJMC
    NJMG
    NJHN
    NJHC
    NJHG

    The 3rd letter in each code is either L, M, or H.

    I want the data validation list in E5 to be based on if the 3rd letter is:

    L then the data validation should equal CoList1
    M then the data validation should equal CoList2
    H then the data validation should equal CoList3

    "CoList1", "CoList2" & "CoList3" are additional named ranges in the sheet
    Attached Files Attached Files
    Last edited by dagindi; 01-24-2011 at 11:23 AM.

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