Adding filters into index/match/array formula

I've found solutions to similar problems, but not one that seems to work for me here.

Let's say I've got a dataset of books that contains Sales, Title and Author and I have a sheet that has 1-10 listed in the A column to denote the rank of the array item. I would like to output a list of the top 10 bestselling books. So I can do something like this:

=INDEX(BookTiltes,MATCH(LARGE(Sales,A2),Sales,0))

(For the 1 in the LARGE function, it's refrencing the 1 in the A column.)

That works great.

But what do I do if I want to filter it down by book author, or any other corresponding value in each Book's row? If I only want to rank books with John Doe as the author, where do I write in that filter? Is it an if statement?

Hi MonsterLobster. Welcome to the forum.

With the author's name in A8 ... you could put a drop down in that cell ... this formula should do that.

Formula:

Please Login or Register  to view this content.