+ Reply to Thread
Results 1 to 4 of 4

How to combine vlookup and search text within cell

  1. #1
    Registered User
    Join Date
    04-14-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to combine vlookup and search text within cell

    Hi All,

    I am trying to create a formula for the following scenario but to no avail. Please note that Cell in Col A Sheet1 have multiple values. e.g A1 contains "ID001, ID002, ID003"

    Sheet 1:
    Col A Col B
    ID001, ID002, ID003 Yes
    ID004, ID005, ID006 No

    Sheet 2:
    Col A Col B
    ID002 [Return Value = Yes]
    ID006 [Return Value = No]
    Last edited by garriebartolome; 04-14-2011 at 09:44 AM.

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: How to combine vlookup and search text within cell

    Seet the attached file
    Attached Files Attached Files

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: How to combine vlookup and search text within cell

    Another interpretation of your problem

    Select from the Drop-Down in B1

    Hope this helps
    Attached Files Attached Files
    Last edited by Marcol; 04-14-2011 at 06:21 AM. Reason: Added dynamic named range to demo workbook
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Registered User
    Join Date
    04-14-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to combine vlookup and search text within cell

    Thanks a lot for your time. It solves my problem.

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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