Forum Discussion
Solved
excel
Hello. I Wanted to find a way to solve this and would appreciate all the help. here I have two columns in different sheets and i want to put them in one sheet correspondingly. the thing is when i ...
=IFERROR(INDEX(Tabelle2!$A$1:$A$10,SMALL(ROW(Tabelle2!$A$1:$A$10),A1)),"")Does this return the expected result? Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=IFERROR(INDEX(Tabelle2!$A$1:$A$10,SMALL(ROW(Tabelle2!$A$1:$A$10),A1)),"")Does this return the expected result? Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
When I try this formula it just returns the first cell and all the other cells return blank so what am I doing wrong??
In the attached file i entered the formula in cell B1 as an arrayformula with ctrl+shift+enter. Then i draged the formula down to cell B15 and it returns the expected results.
- hello, thank you so much now I understand how it works ^^