+ Reply to Thread
Results 1 to 3 of 3

Double Index Match

  1. #1
    Registered User
    Join Date
    11-09-2015
    Location
    Florida
    MS-Off Ver
    O365
    Posts
    61

    Double Index Match

    Hey All:

    Hope everyone is keeping safe. Need some assistance with the attached sample file. I'm trying to match values in two columns to return the value in a third column. I've used something like this many times:

    =INDEX($D2:$D8,MATCH(@$A2:$A8,$F2:$F8,0),1),INDEX(D2:D8,MATCH(@B2:B8,G2:G8,0),1)

    But it doesn't seem to be working any longer. Probably since we moved to O365. I've tried it as an array, too. Basically, trying to say if A:A and F:F match AND B:B and G:G match then return the value in the D:D.

    I've put some notes in the sample file and would greatly appreciate any guidance. I'm sure it's something obvious, but racking my brain at the point.

    Thanks
    WHH3
    Attached Files Attached Files

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Double Index Match

    Try this one in I2 instead (also array formula, use CTRL+ENTER to confirm):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-09-2015
    Location
    Florida
    MS-Off Ver
    O365
    Posts
    61

    Re: Double Index Match

    Oh! I'm embarrassed! That was simple! I've never really used the "&" much and my search of ways to do this didn't yield that option. Much obliged for the quick and helpful response...marking solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index with double match
    By Gaellus in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2019, 06:37 AM
  2. Double Index and Match?? Formula Help!
    By pearson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2016, 11:41 AM
  3. Index with Double Match
    By rajuganapathy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2015, 02:50 AM
  4. Index with double match
    By Gianniz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2015, 06:23 AM
  5. [SOLVED] Double match and index
    By TimothyS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2014, 12:42 PM
  6. Double layered INDEX/MATCH?
    By kuni-d in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-09-2014, 11:01 AM
  7. Double lookup or index and match?
    By dan_manchester in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2013, 09:01 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