+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Search for multiple keywords in a text cell; then look at another if not found

  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    21

    Search for multiple keywords in a text cell; then look at another if not found

    Hi,

    I am attempting to assign industry and focus specializations to individuals based upon keywords found in their job title.

    I have a column of keywords with corresponding values where the search begins, but I want excel to use information contained on another worksheet if it is unable to match a keyword to a word in the job title.

    Example (see attached workbook):
    Would like to search column D for keywords like "Highway" or "Planning" or "Operations" and have column E andF automatically update with corresponding industry and focus information. If that information is not available in Column D, I would like to have Excel vlookup using Column C (employer) and find the corresponding information in the lookup array in the worksheet called 'Toggles' in column D (1o Industry).
    The function I created seems to work somewhat, but I don't want '0' entries if excel doesn't find the info it is looking for. Rather, I would like it to report 'Not Defined'. Other ways of doing this would also be appreciated.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Search for multiple keywords in a text cell; then look at another if not found

    You do realise the the 0 returned from Vlookup means that a match is found in the Toggles sheet, just that there is nothing in column D?

    If so, then try:

    Please Login or Register  to view this content.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    10-25-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    21

    Thumbs up Re: Search for multiple keywords in a text cell; then look at another if not found

    Quote Originally Posted by NBVC View Post
    You do realise the the 0 returned from Vlookup means that a match is found in the Toggles sheet, just that there is nothing in column D?

    If so, then try:

    Please Login or Register  to view this content.
    This worked great! Thanks so much.
    I hadn't considered why the zero was there.
    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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