Forum Discussion

kayem's avatar
kayem
Occasional Reader
Feb 04, 2026

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 if the number of items required is >0. So;

I want the highlighted info from sheets 1-4 to pull through to sheet 5 (product name and number required) if the number required is >0

Hopefully that makes sense - can anyone tell me how to do this? 

excel
Formulas and Functions

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Feb 05, 2026
    =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.

      

Resources