Results 1 to 4 of 4

Conditional INDEX MATCH

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    21

    Conditional INDEX MATCH

    Hi All

    Trying to solve a conditional issue with the attached spreadsheet.

    Basically I have 2 sheets. The first an orders sheet which shows all orders from companies with the date of the order, whether it is a repeat order, and whether it has been delivered. The second sheet a customer account sheet which shows the order history by customer. I have used the following formula =IFERROR(INDEX(Orders!$B$2:$B$23,MATCH(0,INDEX(COUNTIF($A$1:A1,Orders!$B$2:$B$23),,),)),"") to extract the companies from the orders sheet however if a company has had no previous order (i.e. a new customer) and has not recieved a delivery yet I do not want him added to the sheet.

    I have tried amending my formula in different ways but always encounter problems.

    Any help would be great (and leave my day almost complete!)

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional formatting using Index/Match
    By sj123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2014, 03:19 PM
  2. VBA -- Conditional Index/Match
    By ccott23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 10:08 AM
  3. Conditional Formatting with INDEX/MATCH
    By Shanster695 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2013, 02:39 PM
  4. Conditional Formatting with Index/Match function
    By zhopa19 in forum Excel General
    Replies: 5
    Last Post: 10-04-2011, 04:57 AM
  5. Using Index Match and in a conditional Statement
    By vengy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-10-2007, 10:03 AM

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