How to get VStack to exclude data based on word

Question

This is my first time using VStack and it's great, but I need it to completely ignore all rows when column A contains the word "Exclude". Is that possible? If it matters, the Header row name is "Address Slicer" and the word "Exclude" appears in Table 3, but not in Table 1.

=VSTACK(Table1[#All],Table3)

Answer 1

Hi,

Try this

=vstack(A2:B100,filter(C2:D75,C2:C75<>"Exclude"))

Hope this helps.

Answer 2

Thanks, but I'm not following the suggestion. I need the formula to pull in tables 1 & 3 (not a range of cells) and leave out rows in column A that have the word "Exclude"