+ Reply to Thread
Results 1 to 4 of 4

Multiple lookup array for ISNUMBER (MATCH) formula

  1. 04-17-2018, 02:27 AM #1
    erincox2010
    erincox2010 is offline
    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
    Reply With QuoteRegister To Reply
  2. 04-17-2018, 02:35 AM #2
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Multiple lookup array for ISNUMBER (MATCH) formula

    Try

    P2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  3. 04-17-2018, 02:55 AM #3
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Multiple lookup array for ISNUMBER (MATCH) formula

    Another option:
    Please Login or Register  to view this content.
    Quang PT
    Reply With QuoteRegister To Reply
  4. 04-27-2018, 01:50 AM #4
    erincox2010
    erincox2010 is offline
    Registered User
    Join Date
    09-11-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Multiple lookup array for ISNUMBER (MATCH) formula

    Thank you Shukla! That worked perfectly
    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] 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. When using match function can your lookup array be multiple rows and columns
    By heyzeus17 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1