title: Is there a way to vertical look up then transport an entire row data in to proper columns in another sheet?
body: <p>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. </p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1mrRoGrK6Pv0X4AH7QdvoPPYa35oYh7kZIID4oyNAtcs/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1mrRoGrK6Pv0X4AH7QdvoPPYa35oYh7kZIID4oyNAtcs/edit?usp=sharing</a></p>
  
  <p>This is the spreadsheet</p>