One of the most useful and powerful tool in Excel is the Filter. It's easy to use and it contains many incredible options.
How to add the filter option for all your Pivot Table columns? This article explains the trick and the technique
If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.
The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365
Learn how to remove all the filters in Excel with just one click. This step-by-step guide will help you to improve your Excel skills