Filter a row according to a specified value outside of the table

[Marcia]

Hi all. I have a table (B3:C13) where the first named range ($B3:$B13) is "No.", the second named range ($C3:$C13) is "Name". In C2, I enter a number found in named range "No." of the table. I would like Excel to filter the data containing the number that I entered in C2. Is it possible?
It is quite a hassle clicking the dropdown button and selecting the desired number to be filtered. Thank you.



I found a vba solution. Excel VBA AutoFilter: 19 Step-by-Step Examples to Filter Data with Macros