Forum Discussion
Need a formula that looks for a value >0, in multple worksheets
I need a formula that looks at a cell that has a value > 0, and returns the data for the whole row to a "master" worksheet. It has to look across several worksheets (and that is where I am getting c...
This is a task that's considerably easier with access to VSTACK.
=LET(stack,UNIQUE(VSTACK(One:Three!A2:C15),,1),f,FILTER(stack,TAKE(stack,,-1)>0),VSTACK(header,f))
Without VSTACK, my recommendation is to consolidate the sheets because they contain the same type of data and the same headers. It's best to keep 'like data' together in one sheet, if possible.