+ Reply to Thread
Results 1 to 3 of 3

Index Match across multiple columns

  1. #1
    Registered User
    Join Date
    12-03-2017
    Location
    New Jersey
    MS-Off Ver
    2016
    Posts
    3

    Index Match across multiple columns

    Hello I am trying to classify clients by either active or inactive using index match but I am stuck.

    I have one workbook like this.

    Active Inactive
    A D
    B F
    C G

    The other like this

    Client Class
    A
    B
    C
    D
    F
    G

    I would like to have active or inactive show up in the class in the second workbook. Any ideas?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Index Match across multiple columns

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Index Match across multiple columns

    cfitz97 any chance that is two worksheets and not two workbooks?
    Dave

+ 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 to sum multiple match columns
    By rosboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2018, 04:14 PM
  2. INDEX MATCH MATCH multiple columns with same heading
    By djm198 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2016, 02:34 PM
  3. [SOLVED] Index Match across multiple Columns
    By whiZZfiZZ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2016, 01:05 PM
  4. [SOLVED] Multiple IF/THEN INDEX MATCH looking across two columns
    By Aquarock in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-11-2014, 03:35 PM
  5. [SOLVED] index match multiple columns
    By mma3824 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2013, 04:02 PM
  6. [SOLVED] Index Match multiple columns
    By Bravo33 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2013, 10:42 AM
  7. [SOLVED] Index/Match against multiple columns
    By paradox34690 in forum Excel General
    Replies: 8
    Last Post: 04-28-2012, 12:43 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