I have a Google Sheets where Sheet 1 (`Data Q1`) contains all the values for a subject, lesson, names, and percentages of each student's total for a subject. On the next sheet (`NYC/C`) I want to filter a value. 

For Instance: If Data Q 1 contains `Lesedi Selebalo` `Lesson 1` 'Subject Title' insert 'Percentage' contained. 

```
=filter("NamedRange1="Lesson1", Namedrange2="subject name", namedrange3="student name and surname) =Query(Namedrange Percentage)

```

I have included [this document with the example of `PAS Learning Method and Moodle`](https://docs.google.com/spreadsheets/d/1C676nvi745hkvCjsAkxm95yatxX8qkR7GeQOJbnWsaU/edit?usp=sharing).

A sample of data input (Sheet `Data Q1`):

[![Sample of data input (Sheet <code>Data Q1</code>)](https://i.stack.imgur.com/S25Iv.gif)](https://i.stack.imgur.com/S25Iv.gif)

Selection from `NYC/C`:

[![Selection from <code>NYC/C</code>](https://i.stack.imgur.com/3FBX4.gif)](https://i.stack.imgur.com/3FBX4.gif)