Results 1 to 7 of 7

Using index and match to look up employee ID, skill code and return relevant exp date

Threaded View

McHutch Using index and match to look... 04-07-2022, 03:59 AM
Beamernsw Re: Using index and match to... 04-07-2022, 04:39 AM
McHutch Re: Using index and match to... 04-07-2022, 05:08 AM
McHutch Re: Using index and match to... 04-07-2022, 06:43 AM
McHutch Re: Using index and match to... 04-07-2022, 06:56 AM
AliGW Re: Using index and match to... 04-07-2022, 06:48 AM
AliGW Re: Using index and match to... 04-07-2022, 07:00 AM
  1. #1
    Registered User
    Join Date
    11-15-2016
    Location
    Queensland, Australia
    MS-Off Ver
    2013
    Posts
    9

    Using index and match to look up employee ID, skill code and return relevant exp date

    Hi everyone

    I am attempting to create a skill matrix for a work group. I have a clean data source whereby I can match an employee ID and skill code to return the relevant expiry date. From there I will apply traffic light conditional formatting to highlight training that needs to be renewed.

    I am having trouble creating an index / match formula that can handle my two criteria. I have attached a sample data set. Given the large number of employees, it is not practical to use helper columns.

    Appreciate any help offered to solve!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX/MATCH : Finding the Most Relevant Value
    By ExcelNoob233 in forum Excel General
    Replies: 5
    Last Post: 06-30-2021, 01:45 PM
  2. Advancing INDEX RANK RAND to match a skill
    By MrWoods1990 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2020, 06:46 PM
  3. Assign Random Employee if they have a certain skill
    By lpingel09 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-10-2019, 06:11 PM
  4. [SOLVED] INDEX/MATCH multiple criteria and return value w/in Employee Schedule
    By hollywoodj20 in forum Excel General
    Replies: 5
    Last Post: 08-09-2018, 07:49 AM
  5. [SOLVED] INDEX date that MATCH on date range, MATCH code(string)
    By Dahlia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2014, 03:33 AM
  6. Replies: 0
    Last Post: 06-04-2013, 09:01 PM
  7. [SOLVED] MATCH a name and return a relevant value
    By johnmitch38 in forum Excel General
    Replies: 2
    Last Post: 04-19-2012, 05:42 AM

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