Results 1 to 14 of 14

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

Threaded View

anabanana253 Exact match for... 02-19-2018, 06:45 AM
PaulM100 Re: Exact match for... 02-19-2018, 07:21 AM
etaf Re: Exact match for... 02-19-2018, 07:54 AM
anabanana253 Re: Exact match for... 02-19-2018, 08:47 AM
etaf Re: Exact match for... 02-19-2018, 09:02 AM
Glenn Kennedy Re: Exact match for... 02-19-2018, 09:20 AM
anabanana253 Re: Exact match for... 02-19-2018, 09:43 AM
Glenn Kennedy Re: Exact match for... 02-19-2018, 09:54 AM
Glenn Kennedy Re: Exact match for... 02-19-2018, 09:52 AM
Glenn Kennedy Re: Exact match for... 02-19-2018, 10:24 AM
anabanana253 Re: Exact match for... 02-19-2018, 10:31 AM
etaf Re: Exact match for... 02-19-2018, 10:38 AM
Glenn Kennedy Re: Exact match for... 02-19-2018, 10:50 AM
anabanana253 Re: Exact match for... 02-19-2018, 11:16 AM
  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    London, UK
    MS-Off Ver
    2016
    Posts
    11

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

    Hi

    I would like to find an exact match of a grape within a product name of different wines. The problem is that there are so many blends that if I use =if(isnumber(search or =if(isnumber(find the blends will not show since it will only fish for the first part of the grape name rather than the full cell name as I want it to. E.g. it will tag all the "Cabernet Malbec" and "Cabernet Merlot" as "Cabernet Sauvignon" anyway.

    What formula should I use?

    Please see the Excel Spreadsheet attached for example and desired outcomes.

    Column A - Original name - this is what I already have given.
    Column B - Grape - this is what I want as an end effect. I filled it now manually to show an example. That's where the formula would be.

    Matching process - if "Original Name" includes the full "Look for" (Column E) within its cell, tag is as "Come back with" (Column F).
    If it's not in the list, tag it as "Other".

    Please note that the "Original name will always have the full grape varietal name, no shortcuts (like "chard") are used there.
    They will also always start with a capital letter.
    Attached Files Attached Files
    Last edited by anabanana253; 02-19-2018 at 11:26 AM. Reason: solved

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