=FILTER over merged cells, avoiding #SPILL! error.

[Marhier]

Good day everyone.
I've got a small problem I'm hoping someone can help me solve.

I've created a dashboard which has a small table in the top right hand corner, and a table of similar size underneath it.
Above these tables is a search box, where the user types a product code, or supplier name and it returns results based on a filter function.

I believe I know the reason why I'm getting a #SPILL! error - it's because the second column of my table consists of 3 columns of merged cells.
I'm just wondering if it's possible to perform this function over merged cells without getting this error.

My formula is as follows:

=IF(LEN(V6)=0,"No Records Found",TAKE(FILTER(Data[[MStockCode]:[MPriceUom]],ISNUMBER(SEARCH(V6,Data[MStockCode]))+ISNUMBER(SEARCH(V6,Data[Supplier Name]))+ISNUMBER(SEARCH(V6,Data[MPriceUom])),"No Records Found"),20))

Table looks as follows:

All help is greatly appreciated.
Thank you.

 

[Fluff]

Duplicate to: =FILTER over merged cells a set range of cells, avoiding #SPILL! error.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.