+ Reply to Thread
Results 1 to 5 of 5

Need to return data from a table based on multiple conditions

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    Melbourne
    MS-Off Ver
    2010
    Posts
    1

    Need to return data from a table based on multiple conditions

    Want to be able to select data from Column C (3 data validations/drop down menus) and have the corresponding values display in the appropriate fields in column H.

    Not sure if this is possible?
    Attached Files Attached Files

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Need to return data from a table based on multiple conditions

    Got the solution..

    Check the attachment..

    was a bit tricky.. But I managed...

    I have used array formula..
    So use ctrl + shift + enter to enter the formula..
    Don't use only enter..


    Don't forget to click *
    Attached Files Attached Files

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need to return data from a table based on multiple conditions

    Hi and welcome to the forum

    1st make sure that the headings in the table match the "headings in column G.

    Then for H2, H4, and H8, use this REGULAR formula...
    =INDEX($D$18:$R$28,MATCH($C$2&$C$4,INDEX($B$18:$B$28&$C$18:$C$28,0),0),MATCH(G2,$D$16:$R$16,0)+MATCH($C$6,$D$17:$G$17,0)-1)

    For the others, use this REGULAR formula...
    =INDEX($D$18:$R$28,MATCH($C$2&$C$4,INDEX($B$18:$B$28&$C$18:$C$28,0),0),MATCH(G6,$D$16:$R$16,0))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Need to return data from a table based on multiple conditions

    Hi,

    Please find attached the updated file, I have used array formula here. Please press CTRL+SHIFT+ENTER to confirm.
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need to return data from a table based on multiple conditions

    Glad it worked for you and thanks for the feedback Thanks you you as well, Vikus

+ 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. Populating table based on multiple conditions
    By ScottBeatty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2014, 10:13 AM
  2. Replies: 9
    Last Post: 11-24-2011, 01:56 PM
  3. Insert multiple values from seperate table based on multiple conditions
    By drakesong in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2011, 06:04 PM
  4. How do I return a value based on multiple possible conditions?
    By nevermore627 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2006, 08:20 PM
  5. [SOLVED] Formula to return cell contents based on multiple conditions
    By Bill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2005, 06:06 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