Forum Discussion
Solved
Looking for a way to use the filter function to search between two sheets.
I was wondering if it was possible to use the filter function to filter through two sheets: PURCHASES 1 and PURCHASES 2. At the moment, I have a formula that reads like this: =FILTER('PURCHASES ...
=FILTER(VSTACK('PURCHASES 1'!$A$5:$M$5836,'PURCHASES 2'!$A$5:$M$5836),VSTACK('PURCHASES 1'!$A$5:$A$5836,'PURCHASES 2'!$A$5:$A$5836)=C3,"NONE FOUND")
Does it work if you VSTACK the ranges?
=FILTER(VSTACK('PURCHASES 1'!$A$5:$M$5836,'PURCHASES 2'!$A$5:$M$5836),VSTACK('PURCHASES 1'!$A$5:$A$5836,'PURCHASES 2'!$A$5:$A$5836)=C3,"NONE FOUND")
Does it work if you VSTACK the ranges?