Results 1 to 10 of 10

Help - multiconditional index formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    Oporto
    MS-Off Ver
    Excel 2007
    Posts
    31

    Help - multiconditional index formula

    Hi guys,

    here I'm again to claim for your help.

    The issue is that I've to do an INDEX, but I want it to be MULTICONDITIONAL.

    So, into the attached excel you can find, sheet (LIST_VALUES_TO_RETREIVE):

    The A column contains the date which I intend to consider as a condition ("> 01-12-2013" (EUROPE SETTINGS))
    The D column contains the document type which I intend to consider as a condition (only docs started by IMP, via MID function

    The column N, contains the Serial number for which I will search and retrieve the value in column U.

    Into the sheet (LIST_VALUES_TO_SEARCH), a few examples of serial numbers for which I want to have the WO nr, but this time based on other criteria’s such as DATE and TYPE of document.

    Regards
    CMP
    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. MultiConditional Formatting or MultiFormula?
    By easilcat in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2013, 04:17 PM
  2. [SOLVED] multiconditional maximum array
    By MattRNR in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-27-2013, 07:11 PM
  3. Multiconditional if statement problem
    By Steffen Thomsen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2011, 02:52 AM
  4. [SOLVED] How do I set up a countif, or sumif that is multiconditional?
    By Mr. Yanni in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-21-2006, 04:20 AM
  5. Help with multiconditional sumif with range
    By MaxTomas in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 12:05 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