+ Reply to Thread
Results 1 to 4 of 4

Search the special string on the cell combine with vlookup

  1. #1
    Registered User
    Join Date
    08-26-2021
    Location
    HK
    MS-Off Ver
    office2016
    Posts
    4

    Search the special string on the cell combine with vlookup

    Dear All,

    I would like to know the formula to fit my requirements:

    I have the excel file which contain the workstations software inventory list and software valid list. I add column for the software valid or invalid on the software inventory worksheet, but there are a lot of the software version which is valid software e.g. MS office 2012, MS office 2016. The valid software list contain MS office , I want to find the keyword with MS office then return the value valid in the software inventory worksheet. I find the if + isna +vlookup can get the result, but vlookup cannot find the keyword MS office to return valid software.

    May I know the formula to fit my requirements ?


    Thank,

    Hong

  2. #2
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Search the special string on the cell combine with vlookup

    MATCH function may fit your requirement. (passing result to INDEX = VLOOKUP function feature)
    If you can upload a sample file , it will be more clear to find the way.

    Regards.

  3. #3
    Registered User
    Join Date
    08-26-2021
    Location
    HK
    MS-Off Ver
    office2016
    Posts
    4

    Re: Search the special string on the cell combine with vlookup

    Hi Menem,

    Thank you for your reply!

    I don't know how to upload the file here, but I can capture the screen shot , the first is the workstation inventory show full name in different version , then return all the valid software from the second image if the workstation inventory contain the key word

    Attachment 745636

    Attachment 745637
    Attached Files Attached Files
    Last edited by HONG224; 08-27-2021 at 11:07 AM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Search the special string on the cell combine with vlookup

    See yellow banner at top of page on how to attach your sample workbook.

+ 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. String Search For Value Between Special Characters
    By huyza_0100 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-22-2019, 02:00 AM
  2. [SOLVED] VLOOKUP: Search string longer than target string
    By kophanz in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-13-2017, 08:38 AM
  3. [SOLVED] Special VLOOKUP , 3 words search
    By makinmomb in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-04-2015, 03:55 PM
  4. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM
  5. How to combine vlookup and search text within cell
    By garriebartolome in forum Excel General
    Replies: 3
    Last Post: 04-14-2011, 09:43 AM
  6. Replies: 4
    Last Post: 04-14-2011, 06:56 AM
  7. [SOLVED] Using Vlookup in a string search of a cell
    By Ralph Heidecke in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2006, 01:55 PM

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