+ Reply to Thread
Results 1 to 14 of 14

Exact match for =if(isnumber(find ???

Hybrid View

  1. #1
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    Re: Exact match for =if(isnumber(find ???

    PaulM100 formula will work
    BUT the order of the table is very important , otherwise you will get the wrong result
    As you can see i have put just the single words at the end, otherwise , they would return the wrong result

    also I have highlighted yellow, where the result is different to your sample - BUT i think the result is correct

    I have also added where the words are interchanged ie

    Malbec Syrah
    Syrah Malbec

    Both need to be in the lookup table

    we can also use an IFERROR ()
    to return other instead of #N/A

    SO the 61 combinations need to be carefully ordered to get the correct results in the desired output

    see what you thing of the attached
    Attached Files Attached Files
    Last edited by etaf; 02-19-2018 at 09:04 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. add in the parameters to the Find function to only find an exact match.
    By jakeembx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2014, 08:57 AM
  2. [SOLVED] Problem with Find function. Need to find Exact match
    By SMILE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 07:07 AM
  3. Find exact match in two collumn. Please help
    By 11ktran44 in forum Excel General
    Replies: 1
    Last Post: 02-23-2012, 04:00 AM
  4. Find exact match
    By indimonk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2012, 11:25 PM
  5. using Exact with isnumber
    By benaw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2011, 01:02 AM
  6. Find exact match.
    By Robert.Cordani@us.schneider-electric.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2006, 12:55 PM
  7. Find a not exact match using vlookup
    By Russ B in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 04:05 PM
  8. [SOLVED] using vlookup to find exact match
    By Janice Lee via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 03-24-2005, 10:46 PM

Tags for this Thread

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