Hi, I am creating a spreadsheet that pulls information into data validation list and I'm trying to get a second data validation list to pull subsequent data associated with the first.

My first data validation list is using offset(worksheet!C2,0,0,SUMPRODUCT(--(worksheet!C2:C1000<>""))) to pull authors from the array and makes sure I don't get duplicates.

My second data validation list I'm trying to use index match to work with the first and only show books that are associated with the author. I'm using a simple index match formula but unfortunately if I have multiple books with the same author it won't pull all the books for the list. It will only list the first book found. Does anyone know how to overcome this?

Thanks -