SOLVED

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

@deniztopcu 

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.

=FILTER(B4:I21,A4:A21=M2)

 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)
Solution

@deniztopcu 

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

 

=FILTER(Combined_tblFinancials[[itemCode]:[itemDescTr]],Combined_tblFinancials[Symbol]=A1)

 

If you use comma as decimal separator:

 

=FILTER(Combined_tblFinancials[[itemCode]:[itemDescTr]];Combined_tblFinancials[Symbol]=A1)

 

See the attached workbook.

thank you for your answers.
my problem is solved.