title: How To Filter Rows Based On A List From Another Sheet? (Google Sheets)
body: <p>In Excel, it is quite easy to filter rows based on a list from another sheet. But, Google Sheets does not have an advanced filter option. It therefore is not possible to filter a column by list range and criteria range in the same way that one would in Excel. So, how do you filter rows based on a list from another sheet in Google Sheets?</p>
  
  <p><strong>Worksheet to Be Filtered</strong></p>
  
  <p><img src="https://i.stack.imgur.com/Lplfs.png" alt="Worksheet"></p>
  
  <p><strong>Worksheet with Filter List</strong></p>
  
  <p><img src="https://i.stack.imgur.com/VzXHW.png" alt="Filter List"></p>