+ Reply to Thread
Results 1 to 2 of 2

Return specific line of text based on range of text values entered

  1. #1
    Registered User
    Join Date
    01-12-2022
    Location
    England
    MS-Off Ver
    2013
    Posts
    1

    Return specific line of text based on range of text values entered

    Good morning,

    Apologies if this has already been asked multiple times, I am fairly new to using Excel formulas and I have tried to find the answer on here but can't find one that seems to match what I need.

    I manage training for large groups of people in my business and this is done by uploading a spreadsheet of user info to our third party e-learning platform. Each user has to complete a specific introductory module based on their job role/job title. There are only 8 different modules but 200+ job titles so knowing which one to pick isn't always straightforward without having to look the information up.

    What I need is a formula that returns the name of the module required based on the job title entered in a different cell, so e.g. if the job title entered can be found in THIS range of values, return module X, if found in THAT range of values, return module Y, etc...

    Any help would be greatly appreciated.

    Many thanks.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,365

    Re: Return specific line of text based on range of text values entered

    The easiest way would be to create a table of job roles and the relevant course next to it. Then you can use VLOOKUP or INDEX/MATCH to do the lookup for you.

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Return a the latest Valeu (TEXT) entered based on a criteria
    By asantos80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2017, 02:44 PM
  2. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  3. [SOLVED] find non-blank cells and return line with only specific text
    By greg19 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2014, 01:43 AM
  4. Replies: 2
    Last Post: 09-07-2013, 07:50 PM
  5. [SOLVED] Return specific text if a different text is contained anywhere in a range of cells
    By ciayers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2013, 05:54 PM
  6. Display msgbox when specific text entered in specific range
    By Ali_Riza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:05 AM
  7. Search text string for range of text values - return match
    By crugg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2010, 09:55 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