+ Reply to Thread
Results 1 to 4 of 4

Match 2 Lists Depending on a the first Characters of the cell-which will be variable

  1. 10-14-2011, 09:16 PM #1
    denise001
    denise001 is offline
    Registered User
    Join Date
    12-01-2008
    Location
    London
    Posts
    25

    Match 2 Lists Depending on a the first Characters of the cell-which will be variable

    Hello Excel Forum

    Just cannot get my formula to work 100% as I desire it to.

    I have a list of countries (sheet1) and want to tag in the next column if any of them are in another list called Sanctioned Countries.

    I want to see 3 responses:
    - Exact Match
    - Possible Match (based on the match of the numbers of characters I select)
    - No Match (based on the match of the numbers of characters I select)

    My formula picks up the Exact matches - no problem - but it is not working for the other 2 responses. I have tried removing the "istext()" part of the formula because I don't think the formula actually needs this.

    Been having a go all evening without hitting the bullseye!

    Hope it also provides an interesting problem for other forum users to learn from as well.
    Many thanks
    Denise
    Attached Files Attached Files
    Last edited by denise001; 10-15-2011 at 06:06 AM. Reason: Clarity
    Reply With QuoteRegister To Reply
  2. 10-14-2011, 10:18 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Match 2 Lists Depending on a the first Characters of the cell-which will be varia

    In cell B3, try:

    Please Login or Register  to view this content.
    and autofill down.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 10-15-2011, 06:06 AM #3
    denise001
    denise001 is offline
    Registered User
    Join Date
    12-01-2008
    Location
    London
    Posts
    25

    Re: Match 2 Lists Depending on a the first Characters of the cell-which will be varia

    Thank you so very much ConneXionLost.
    It works perfectly.
    Appreciate your time to help me.

    Hope others can use this for "fuzzy searches".

    What I can do now is apply the Data Filter and see what matches I am getting - depending on how many characters you take. Obviously the less characters the more possible matches - 3 or 4 Character search is about right to eyeball the list.

    Many thanks once again.
    Regards
    denise
    Reply With QuoteRegister To Reply
  4. 10-16-2011, 02:46 AM #4
    e4excel
    e4excel is offline
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Match 2 Lists Depending on a the first Characters of the cell-which will be varia

    Quote Originally Posted by denise001 View Post
    Hope others can use this for "fuzzy searches".
    Agreed Denise,

    Its indeed very useful for the FUZZY Searches...

    Great work Connexions..

    Warm Regards
    e4excel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1