Forum Discussion
An alternative to the function FILTER
Hello, I have difficulties with getting information from one array in one sheet to another array in another sheet, for the following reason : I have one data in common between the two arrays, an...
=INDEX(Tableau2[Fruit],SMALL(IF((Tableau2[Alley]=1)+(Tableau2[Alley]=2),ROW(Feuil1!$1:$4)),ROW(Feuil1!1:1)))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.