Combine two filter functions

[Knockoutpie]

Hi all, how can I combine these two formulas? I just cannot wrap my head around vstack..

FILTER('Sales'!G:G,'Sales'!P:P=Summary!A1)
FILTER('Backlog'!G:G,'Backlog'!I:I=Summary!A1)

@Fluff, i've read your previous posts, seems you have the best knowledge on this.

 

[Joe4]

I think you can do that pretty easily with the VSTACK function.
See: How to use Microsoft Excel’s VSTACK() function to combine multiple data sets

So I think your formula would be like:

=VSTACK(FILTER('Sales'!G:G,'Sales'!P:P=Summary!A1),FILTER('Backlog'!G:G,'Backlog'!I:I=Summary!A1))

 

[Knockoutpie]

I think you can do that pretty easily with the VSTACK function.
See: How to use Microsoft Excel’s VSTACK() function to combine multiple data sets

So I think your formula would be like:

=VSTACK(FILTER('Sales'!G:G,'Sales'!P:P=Summary!A1),FILTER('Backlog'!G:G,'Backlog'!I:I=Summary!A1))

thanks Joe, almost had it myself, i was starting to read-up on the function here.

Excel VSTACK Function – The One Excel Formula to Append Them All

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

www.xelplus.com

 

[Joe4]

You are welcome.