+ Reply to Thread
Results 1 to 4 of 4

Matching text problem

  1. #1
    Registered User
    Join Date
    12-14-2017
    Location
    UK
    MS-Off Ver
    EXCEL 2013
    Posts
    6

    Matching text problem

    Hi Guys

    I am a very basic beginner on excel and am trying to wrap my head around the formulas.

    Would anyone know how to solve the attached problem?

    I was trying to do something with the IFNA formula but no luck.

    Thanks in advance

    Tom
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,654

    Re: Matching text problem

    Hi TOM5491.

    Try this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Although the syntax is the same IFERROR works in more Excel versions and covers more error types. IFNA won't work in versions earlier than Excel 2013, and it is limited to #N/A errors only.

    That said this is the IFNA version.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Online HELP explains it as does this link http://www.excelfunctions.net/
    Last edited by FlameRetired; 12-17-2017 at 03:24 PM.
    Dave

  3. #3
    Registered User
    Join Date
    12-14-2017
    Location
    UK
    MS-Off Ver
    EXCEL 2013
    Posts
    6

    Re: Matching text problem

    Hi FlameRetired,

    Thanks for the assistance, I have tried the online help. I'm ok with the functions as they are separately but it's when I need to combine them, that I get it wrong.

    Unfortunately, I didn't have much luck with the formula you've provided. I'm going to try to use IFNA with VLOOKUP and with the MATCH.

    Thanks

    Tom
    Last edited by TOM5491; 12-17-2017 at 05:46 PM.

  4. #4
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,654

    Re: Matching text problem

    I guess I am not clear on exactly what you want. The formulas are working at my end.

    Examine the attached and please tell me what I am missing.

    Edit There are trailing spaces in the data column B. Those will defeat matching 'Contact Types'. See what happens when you clean up the data.
    Attached Files Attached Files
    Last edited by FlameRetired; 12-17-2017 at 08:09 PM.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1