+ Reply to Thread
Results 1 to 4 of 4

INDEX MATCH with multiple columns

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    INDEX MATCH with multiple columns

    A B C D E F
    1 Month Location Morning Lunch Afternoon Night
    2 January WA 2000 100 1000 500
    3 January OR 500 300 400 750
    4 January CA 750 400 30 550
    5 February WA 3 9 100 50
    6 February OR 5 200 100 95
    7 February CA 8 10 50 85
    8 March WA 9 60 200 75
    9 March OR 10 75 60 65
    10 March CA 5 50 425 55

    Value
    WA Afternoon March

    Can someone please help me with the formula to look for value for "March, WA, Afternoon" using INDEX MATCH?
    I can't use index- match when it has 2 columns criteria.
    Please help. Thank you

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: INDEX MATCH with multiple columns

    Here is an example of Index and Match to extract a single record from your data: Enter the month and location under the headings provided.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    10-08-2013
    Location
    seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: INDEX MATCH with multiple columns

    Thank you!!

  4. #4
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: INDEX MATCH with multiple columns

    I tried without helper column.

    Please try this file as well.
    Attached Files Attached Files
    Last edited by ramananhrm; 10-08-2013 at 11:53 PM.
    Please click 'Add reputation', if my answer helped you.

+ 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 multiple columns
    By Bravo33 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2013, 10:42 AM
  2. Index Match Across Multiple Columns
    By FFastZB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2013, 04:58 PM
  3. [SOLVED] Index/Match across multiple columns
    By BB1972 in forum Excel General
    Replies: 2
    Last Post: 07-27-2012, 12:05 PM
  4. [SOLVED] Index/Match against multiple columns
    By paradox34690 in forum Excel General
    Replies: 8
    Last Post: 04-28-2012, 12:43 PM
  5. Index/Match but with multiple columns?
    By notleonardo in forum Excel General
    Replies: 4
    Last Post: 11-17-2011, 07:16 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