Index Match for Dropdown

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.

Use a pivot, see attached.

Try this, you will have to hide some columns View attachment Tapatalk-Download119495430Book1.xlsx

Sent from my SM-G965F using Tapatalk