Forum Discussion

Olimpiu's avatar
Olimpiu
Copper Contributor
Mar 12, 2025
Solved

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 ( t...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    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.

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