+ Reply to Thread
Results 1 to 3 of 3

Determine if value is contain in named range

  1. #1
    Registered User
    Join Date
    05-15-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Determine if value is contain in named range

    I have a spreadsheet that I used to track if members have required training at specific levels

    A:1 - Name B:1 - Submission status C:1 - Certificate obtained D:1 - Required Certificate level E:1 - Compliance Status

    B - Can be awaiting or submitted C - Name of the certificate D - There are 14 required certificate levels and each contains several certificates that a member can obtain (placed in named ranges on another sheet) E - Will be one of a few options: Compliant, Non-Compliant; needs submission, or Compliant; does not meet required level

    I would like a formula or VB that can determine if the member's certificate meets the requirement of the level for the position they occupy. If a member has the certificate or one of a higher level then they are compliant.

    I want the formula or code to determine which range to start parsing through based on the required level first then move through the remaining higher levels until it finds a match or it returns a false

    ie: Level I certs include: CERT A & CERT B/Level II certs include: CERT B, CERT C, CERT D

    Member Jane Doe occupies a level I position and he has obtained CERT C, so she would be compliant.

    Member John Doe occupies a level II position and he has obtained CERT A, so he would not be compliant because his position requires a higher level certification
    Attached Files Attached Files
    Last edited by m.skinner; 05-15-2017 at 02:43 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,269

    Re: Determine if value is contain in named range

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    05-15-2017
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Determine if value is contain in named range

    I've attached a sample of my spreadsheet. The info I need displayed is on the 1st sheet. All of the inputs are located on the 2nd sheet.

+ 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. [SOLVED] Determine how many items in a list do not belong to a named range
    By Travisty in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-07-2015, 01:13 AM
  2. [SOLVED] Determine what Named Range the Target Address is and return Named Range Name
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2012, 10:49 PM
  3. IF function to determine #N/A in a named range
    By corkyo4 in forum Excel General
    Replies: 3
    Last Post: 04-20-2010, 04:48 AM
  4. Determine if named range is empty / null
    By beeawwb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-02-2008, 12:22 AM
  5. value in cell to determine which named range used in formula
    By trashnation in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2007, 04:20 AM
  6. Determine the sheet of a Named range
    By msing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2006, 03:12 AM
  7. Determine if Named Range exists in Worksheet
    By jkt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2006, 01:00 PM

Tags for this Thread

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