Forum Discussion
Formula help
Hi all, I have a spreadsheet with four sheets of data (different suppliers, then organised by catalogue/non-catalogue products), and I want the product name to pull through to a fifth summary sheet...
=IFERROR(INDEX(Tabelle1!$B$3:$B$1000,
SMALL(IF(ISNUMBER(Tabelle1!$E$3:$E$1000),
ROW(Tabelle1!$E$3:$E$1000)-2),ROW(A1))),"")This formula works in my sample file in modern and legacy Excel for the non-catalogue products of sheet "Tabelle1". 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 2024.
It returns the results from one sheet to the summary sheet. You can adapt these formula to all four sheets. The other formulas are in the attached file.
If you have access to modern Excel and it's functions such as VSTACK, CHOOSECOLS, FILTER... then there's a possibility to return all results from the four sheets in one step.
Thanks so much! How do I use the vstack, choosecols, filter to return results from the four sheets in one step?
