Page 5 of 5 FirstFirst ... 3 4 5
Results 41 to 47 of 47

Thread: vLookup with wildcards (equivalent of "contains") - best solution?

  1. #41
    Neophyte chart68's Avatar
    Join Date
    Jan 2015
    Location
    Reading UK
    Posts
    4
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by Bob Phillips View Post
    Claire, that VLOOKUP should work if I understand the data correctly. Give an example where it doesn't work.
    I've uploaded my spreadsheet, thanks Claire
    Attached Files Attached Files

  2. #42
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,604
    Articles
    0
    Excel Version
    O365
    You have a real problem there Claire. There is no realistic way of determining how those addresses map onto those areas. You need some sort of intermediary mapping table that can do that lookup.

  3. #43
    Neophyte chart68's Avatar
    Join Date
    Jan 2015
    Location
    Reading UK
    Posts
    4
    Articles
    0
    Quote Originally Posted by Bob Phillips View Post
    You have a real problem there Claire. There is no realistic way of determining how those addresses map onto those areas. You need some sort of intermediary mapping table that can do that lookup.
    Thanks Bob, never mind it was worth a try your help and expertise is most appreciated. Claire

  4. #44

    Lookup Contains Value


    I have two data one subscriber ID and Campaign Name. Campaign name contains subscriber ID.

    Now looking for Campaign Name in in front of contains subscriber ID.

    Please help to solve this...
    Attached Files Attached Files

  5. #45

    I can't get this to work. Please Help!

    Quote Originally Posted by Bob Phillips View Post
    I think this ARRAY formula does what you want

    =--SUM(IFERROR(MATCH("*"&author_names!$A$2:$A$6&"*",A2,0),0))
    I've tried adding this formula to the spreadsheet givenauthor_names.xlsx but I can't get it to work. Does it work in excel 2003? If so it may be that I'm not getting the array to work properly.

    Would someone mind posting the final working excel file here for me so I can see how it looks when working or suggest where I'm going wrong in trying to get this formula into the spreadsheet.
    Last edited by Jeremy Fisher; 2016-06-28 at 06:28 PM.

  6. #46

    Example

    Quote Originally Posted by Jeremy Fisher View Post
    I've tried adding this formula to the spreadsheet givenauthor_names.xlsx but I can't get it to work. Does it work in excel 2003? If so it may be that I'm not getting the array to work properly.

    Would someone mind posting the final working excel file here for me so I can see how it looks when working or suggest where I'm going wrong in trying to get this formula into the spreadsheet.
    Here's my attempt to do this which doesn't work for me.author_names1.xlsx

  7. #47

    Got it working

    OK I got it to work with a different formula which I'll post here in case anyone is looking for a working file like I was: author_names2.xlsx

Page 5 of 5 FirstFirst ... 3 4 5

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •