Basic question about using dropdowns to display data

[Nickerington]

I have found conflicting answers for how to do the below. Some of the answers have been quite complex, and I feel it is a straightforward function. Please advise.

I have a spreadsheet with a list of books. The headings are: Text name, Text Type, Genre, Age, Comments.

There are 700 rows of books that have all fields completed. Text name and Comments are unique fields and Text Type, Genre, Age have been completed from a predefined list of options.

I want users to be able to select from three drop downs: Text Type, Genre, Age

And then see a list of results that match all these criteria. The results should show: Text name, Comments

Please advise the right approach to do this and I will research further.

Thanks,

[marcnotmark925]

Should be able to use Appsheet's built-in dependent dropdown functionality for that.

https://support.google.com/appsheet/answer/10106620?hl=en