Combine two filter results in one sheet

[nburaq]

Hi All,
I have two similar tables at two different sheets. Is there any possibility to combine these two filtered results to show at another sheet? Maybe combination of filter and vstack?
I dont need unique values etc.. it is enough if it is filtered based on search

PS: I use this formula based on key search (Sheet1 result page, keyword at B1)
=FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results")
=FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results")

 

[Fluff]

How about

=VSTACK(FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results");FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results"))

 

[nburaq]

How about

=VSTACK(FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results");FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results"))

Works perfect ! Is there any chance to hide #N/A if one of searches come without any result? Or placing "No results" to every column? Thanks again!

 

[Fluff]

You can use expand for that like (I've just doe the 1st filter)

=VSTACK(EXPAND(FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results");;13;"No Results");FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results"))

 

[nburaq]

You can use expand for that like (I've just doe the 1st filter)

=VSTACK(EXPAND(FILTER(Sheet1!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet1!$A$2:$A$999));"No Results");;13;"No Results");FILTER(Sheet2!$A$2:$M$999;ISNUMBER(SEARCH($B1;Sheet2!$A$2:$A$999));"No Results"))

Thanks again!

 

[Fluff]

You're welcome & thanks for the feedback.