Results 1 to 4 of 4

Multiple lookup array for ISNUMBER (MATCH) formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Multiple lookup array for ISNUMBER (MATCH) formula

    Hey guys!

    I've attached a spreadsheet and basically need to add another lookup array to an existing formula. The formula is in column "P" in the "Raw Data" Tab. The formula currently returns TRUE if the Incident ID appears in the "Digicall Remittance" tab in column "K". What I need is for the formula to return TRUE if the Incident ID appears in the "Digicall Remittance" tab in column "K" or in the "AP fleet remittance" tab in column "B".

    Appears in one tab - TRUE
    Appears in both - TRUE
    Appears in none - FALSE

    Thank you for your help
    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. [SOLVED] INDEX MATCH where lookup array is multiple columns
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2017, 05:53 AM
  2. Need an array possibly INDEX/MATCH formula with multiple lookup criteria.
    By TheClaw2323 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2015, 09:59 AM
  3. Lookup OR Index/Match with multiple Array's
    By Numnum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2014, 05:32 AM
  4. LOOKUP with Multiple Criteria (ARRAY INDEX and MATCH)
    By snowktt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2014, 02:24 AM
  5. [SOLVED] Summation across row using sumproduct/isnumber/match and named array(s)
    By samuk1000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2013, 02:24 AM
  6. Replies: 3
    Last Post: 09-30-2011, 02:50 AM
  7. Isnumber, match, sumif,lookup
    By David Brown in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2011, 02:35 PM

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