fetch the rows that match the searched value

Occasional Contributor

Excel.pngplease help to fetch the rows that match the searched value as in the example.

4 Replies


The easiest way would be to use the FILTER() function. However, this is somewhat newer and is therefore not yet available to everyone. If it works for you, you can use the following function in cell M4. Please copy the header rows from the original data.


 If you can't use FILTER() yet, please give some feedback.

Unfortunately I tried what you said but it didn't work, I think it doesn't happen because I want to do it on a separate page.
I have attached my sample excel file.

best response confirmed by deniztopcu (Occasional Contributor)


If you have Microsoft 365 of Office 2021, you can use




If you use comma as decimal separator:




See the attached workbook.

thank you for your answers.
my problem is solved.