+ Reply to Thread
Results 1 to 4 of 4

Return Value from table using multiple criteria

  1. #1
    Forum Contributor
    Join Date
    07-08-2010
    Location
    ireland
    MS-Off Ver
    Excel 2007
    Posts
    121

    Return Value from table using multiple criteria

    Hi All,

    wondering anyone can help me.

    I have a table. Column A contain month, 1 to 12. and Column B, C, D, E and F contain Department headings. What i am looking for is is to use formula to pull value from table using multiple criteria as shown below.

    Mnth TB TD TC LM FSM
    1 a1 b1 c1 d1 e1
    2 a2 b2 c2 d2 e2
    3 a3 b3 c3 d3 e3
    4 a4 b4 c4 d4 e4
    5 a5 b5 c5 d5 e5
    6 a6 b6 c6 d6 e6
    7 a7 b7 c7 d7 e7
    8 a8 b8 c8 d8 e8
    9 a9 b9 c9 d9 e9
    10 a10 b10 c10 d10 e10
    11 a11 b11 c11 d11 e11
    12 a12 b12 c12 d12 e12

    Requirement:
    Select Department Select Month Return Value
    TC 3 c3

    The file is also attached for your reference. Any help will be greatly appreciated

    Regards

    Shido
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,537

    Re: Return Value from table using multiple criteria

    Have a look at the attached. Using INDEX and MATCH you can do just this.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    07-08-2010
    Location
    ireland
    MS-Off Ver
    Excel 2007
    Posts
    121

    Re: Return Value from table using multiple criteria

    it works great. Thank you for your help. This is is what i am looking for.
    Regards
    Shido

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,537

    Re: Return Value from table using multiple criteria

    Glad to help, Shido

    Feel free to mark the thread as SOLVED if you're happy with the answer.

    BSB.

+ 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. How to return data from other table using two criteria
    By shardin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 09:27 AM
  2. Replies: 5
    Last Post: 06-21-2012, 10:36 AM
  3. Replies: 6
    Last Post: 05-21-2012, 11:51 PM
  4. Return a value from a multiple criteria table
    By cktung in forum Excel General
    Replies: 6
    Last Post: 12-26-2011, 03:39 AM
  5. Search table with multiple criteria and return row
    By grunwaldlove in forum Excel General
    Replies: 2
    Last Post: 11-11-2009, 11:18 AM

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