1
votes

Essentially I have a list of people on a mailing list. I need to find the people that are volunteers on that list and then transport that specific data into a volunteer worksheet.

https://docs.google.com/spreadsheets/d/1mrRoGrK6Pv0X4AH7QdvoPPYa35oYh7kZIID4oyNAtcs/edit?usp=sharing

This is the spreadsheet

1

1 Answers

0
votes
=FILTER({'data sheet'!A2:A, 'data sheet'!C2:C, 'data sheet'!B2:B}, 'data sheet'!D2:D="yes")

0