+ Reply to Thread
Results 1 to 8 of 8

IFERROR + FIND multiple matches

Hybrid View

  1. 06-15-2016, 07:30 PM #1
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: IFERROR + FIND multiple matches

    Here's another one...

    =IF(OR(AZ12={"Apple","Orange","Banana"}),G12,0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  2. 06-16-2016, 03:05 PM #2
    Kanuck
    Kanuck is offline
    Registered User
    Join Date
    06-15-2016
    Location
    BC
    MS-Off Ver
    excel 2013
    Posts
    52

    Re: IFERROR + FIND multiple matches

    That worked as well Tony, thank you!
    Reply With QuoteRegister To Reply
  3. 06-16-2016, 07:14 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: IFERROR + FIND multiple matches

    You're welcome. Thanks for the feedback!
    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)

Similar Threads

  1. [SOLVED] Multiple IFERROR or IFERROR w/ If Statements
    By SanchoPanza1 in forum Excel General
    Replies: 4
    Last Post: 03-31-2016, 08:09 PM
  2. [SOLVED] Best way to find multiple matches
    By megantscherer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2015, 08:33 AM
  3. [SOLVED] What formulas can I use to find matches based on multiple criteria
    By Jonathan68 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2014, 02:22 PM
  4. To find if vlookup matches multiple values
    By karthik11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2013, 06:19 AM
  5. Find unique matches for multiple criteria within a row of cells
    By Chase in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2012, 03:11 PM
  6. Excel 2007 : How do I find cell matches one of multiple criteria?
    By blessguy in forum Excel General
    Replies: 8
    Last Post: 02-15-2012, 05:05 AM
  7. Find the last-row result of multiple matches?
    By goodiein2808 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2011, 11:53 AM

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