All: With help from some of this site’s suggestions, I’ve got the following formula to pull from several worksheets: =FILTER(VSTACK(FRR:SOD!G3:M200),(VSTACK(FRR:SOD!K3:K200)<>””)*(VSTACK(FRR:SOD!K3:K200)=”ABC XXXX”)) Is there a way to filter for a partial match within “ABC XXXX”? Think of ABC as a location, and XXXX as a job/position at that location. I would […]