Results 1 to 6 of 6

Issue with array formula index and match giving N/A WHEN 3 CRITERIA is involved

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Issue with array formula index and match giving N/A WHEN 3 CRITERIA is involved

    I have a workbook with 2 sheets quota and database .

    My goal is extract data from database from column A ,D AND G as criteria and lookup column F of same sheet. and insert correct data in column F of quota sheet .

    I have taken a small sample as the database is much bigger of 5000 rows .

    I used index and match through concatenation as array form. but when I have data in column A and G are same criteria but column D , I am getting N/A .

    There is an issue with match concatenation which evaluate N/A.

    Can anyone assist I am stuck

    
    =INDEX(DATABASE!$E$2:$E$6,MATCH(A2&D2&G2,DATABASE!$A$2:$A$6&DATABASE!$C$2:$C$6&DATABASE!$F$2:$F$6,0))
    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 array giving first value when no match
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2019, 09:30 AM
  2. Replies: 6
    Last Post: 12-13-2017, 10:08 AM
  3. Replies: 5
    Last Post: 04-19-2016, 04:17 PM
  4. 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
  5. Array Formula - Index / Match - Dedupe & filter criteria
    By rtiger in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-29-2014, 03:18 PM
  6. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  7. Replies: 4
    Last Post: 03-27-2014, 01:09 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