Forum Discussion
Excel - Vstack help.
I feel like I'm missing something simple. but here goes. I'm using the VStack function to search multiple tables on separate sheets. Its working wonderfully except as it runs through each filter func...
=LET(result, VSTACK(FILTER(Narkiewiecz[[House Code]:[Invoice Paid?]], Narkiewiecz[House Code] = Access!$B$4, ""),FILTER(Table47[[House Code]:[Invoice Paid?]], Table47[House Code] = Access!$B$4, ""),FILTER(Table48[[House Code]:[Invoice Paid?]], Table48[House Code] = Access!$B$4, ""),FILTER(Table49[[House Code]:[Invoice Paid?]], Table49[House Code] = Access!$B$4, ""),FILTER(Table410[[House Code]:[Invoice Paid?]], Table410[House Code] = Access!$B$4, "")), FILTER(result, CHOOSECOLS(result, 1)<>""))
