+ Reply to Thread
Results 1 to 2 of 2

INDEX MATCH with 2nd MATCH lookup_value is in column

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 365
    Posts
    22

    INDEX MATCH with 2nd MATCH lookup_value is in column

    Hello!

    I'm attempting to use INDEX(MATCH, MATCH) to populate columns G and I in tab table1, below,

    Attachment 640965

    with data from tab table2, below. My formula is returning #N/A.

    Attachment 640966
    Please Login or Register  to view this content.
    I think the problem is my second MATCH lookup_value is arranged in a column. It's my first time doing it this way. I usually use INDEX(MATCH, MATCH) with MATCH lookup_values arranged in row and column, respectively.

    Is this not the correct way to do it? Or is the problem different?

    Thank you!
    Attached Files Attached Files
    Last edited by rkong; 09-11-2019 at 12:05 AM.

  2. #2
    Registered User
    Join Date
    09-08-2016
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 365
    Posts
    22

    Re: INDEX MATCH with 2nd MATCH lookup_value is in column

    Never mind, I figured it out. Since lookup_array in 2nd MATCH refers to text, its lookup_value needs to be converted to TEXT, so below:
    Please Login or Register  to view this content.
    Thanks for visiting!

+ 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. [SOLVED] Index match - column and row (vertical / horizontal) match - equal or greater
    By lukemc11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2018, 05:36 PM
  2. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  3. [SOLVED] Index match match with the column number determined by two rows???
    By bridge4444 in forum Excel General
    Replies: 2
    Last Post: 08-08-2016, 04:23 AM
  4. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  5. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  6. Utilizing INDEX/MATCH to match variables by column only
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-29-2011, 09:53 AM
  7. match value in one column to adjacent value: use vlookup or index/match?
    By conorsgaffney in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2010, 04:59 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