Results 1 to 3 of 3

Thread: Index Match for Dropdown

  1. #1
    Neophyte jmvcrz's Avatar
    Join Date
    Nov 2019
    Posts
    1
    Articles
    0
    Excel Version
    Excel 2010

    Index Match for Dropdown



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone,

    can you help me with my workbook? If I select an insurer in N2, I wanted to show the list with the specific insurer, names and comment in M9 to O14, however, looks like my formula is returning just one row.

    attached is the workbook.

    Thank you.
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,621
    Articles
    0
    Excel Version
    365
    Use a pivot, see attached.
    Attached Files Attached Files

  3. #3
    Seeker Docharding's Avatar
    Join Date
    Dec 2018
    Posts
    6
    Articles
    0
    Excel Version
    2016
    Try this, you will have to hide some columns Tapatalk-Download119495430Book1.xlsx

    Sent from my SM-G965F using Tapatalk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •