Results 1 to 9 of 9

Thread: Fetch multiple values based on criteria

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-05-2012, 05:57 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Assume your data in A1:C16 row 1 being the header

    Type the Agency name in G1

    In G2 and copied down and across,

    =IFERROR(INDEX(B$2:B$16,SMALL(IF($A$2:$A$16=$G$1,R OW(B$2:B$16)-ROW(B$2)+1),ROWS(G$2:G2))),"")

    It's an array formula. Confirmed with CTRL + SHIFT + ENTER
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 04-07-2012, 02:42 AM #2
    Lucero
    Lucero is offline
    Junior Member
    Join Date
    Apr 2012
    Posts
    8
    Rep Power
    0
    Dear Admin,
    Thank you so much for your help!! The array formula is exactly what I needed!!! You Rock!!!
    Reply With Quote Reply With Quote
  3. 04-07-2012, 02:43 AM #3
    Lucero
    Lucero is offline
    Junior Member
    Join Date
    Apr 2012
    Posts
    8
    Rep Power
    0
    Thank you so much for your help!! The array formula is exactly what I needed!!! You Rock!!! :D
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values
    By Luke M in forum Excel Help
    Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  3. Sum values based on multiple criteria
    By Jorrg1 in forum Excel Help
    Replies: 8
    Last Post: 01-07-2013, 03:04 PM
  4. Sum values based on multiple criteria
    By vmath in forum Excel Help
    Replies: 1
    Last Post: 05-07-2012, 08:53 AM
  5. Fetch Data from multiple sheets based on criteria VBA
    By Raj Kumar in forum Excel Help
    Replies: 7
    Last Post: 03-06-2012, 07:49 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
  •  

Forum Rules