+ Reply to Thread
Results 1 to 4 of 4

"VLOOKUP" from cells containing value of interest amongst other values

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    44

    "VLOOKUP" from cells containing value of interest amongst other values

    Hello,

    Apologies if the title is not very clear, I will try to explain what I am trying to do (unsuccessfully after a few attempts and googling).

    I would like to perform a VLOOKUP or similar on data that is organised like this:

    A B C D E
    1 Data of interest Source array Source array
    2 text2 text1, text2, text3 value1

    Importantly, the text in D2 is all present in the same cell. I would basically like to get "value1" in B2, corresponding to a match with the content of B1. If the list in D2 was not separated by commas, I would do a simple VLOOKUP and get it, but I don't know how to extract "text2" from the cell to perform the VLOOKUP. I've tried combinations of VLOOKUP and MATCH but I can't seem to figure it out.

    Many thanks for your help and your time on this basic question!

    G.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: "VLOOKUP" from cells containing value of interest amongst other values

    Try including wildcards. Something like this:

    =INDEX(E:E,MATCH("*"&A2&"*",D:D,0))

  3. #3
    Registered User
    Join Date
    03-23-2012
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    44

    Re: "VLOOKUP" from cells containing value of interest amongst other values

    Thank you! Works perfectly!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: "VLOOKUP" from cells containing value of interest amongst other values

    Quote Originally Posted by guillm View Post
    Thank you! Works perfectly!
    You're welcome. Happy to help!

+ 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. How to determine "interest rate" to make two cells be equal
    By livemusic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-08-2015, 11:10 AM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Replies: 3
    Last Post: 04-14-2013, 11:53 PM
  5. [SOLVED] Pasting values between ranges in different workbooks: "Range" works but "Cells" doesn't
    By Flaubert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2013, 01:19 PM
  6. Replies: 2
    Last Post: 09-25-2012, 12:53 AM
  7. Replies: 3
    Last Post: 02-16-2011, 02: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