Forum Discussion

Olimpiu's avatar
Olimpiu
Copper Contributor
Mar 12, 2025

Please, help in importing data from another sheet

Hello !

I am a beginer in excel using, so I ask for a little help.

I have a file with more sheets.

I work in Sheet 2.

I want to import from Sheet 1 all the rows that contains a specific value ( text)

For example : in Sheet 1 I have 100 rows with data. In 20 of the rows I have one cell ( in column A or column B) with the text " flower". 

So, I want to import all that 20 rows automaticaly in Sheet 2.

It is possible ?

Thank you for your time !

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Mar 13, 2025
    =IFERROR(INDEX(Tabelle2!C$2:C$100,SMALL(IF((Tabelle2!$A$2:$A$100=Tabelle1!$A$2)+(Tabelle2!$B$2:$B$100=Tabelle1!$A$2),ROW($A$1:$A$99)),ROW($A1))),"")

    This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021. The formula is filled across range B2:H25 in my sample. The filter or import criteria can be entered in cell A2.

    If you work with Excel for the web or Office 365 you can apply the FILTER function which would be the better alternative in my opinion.

Resources