In this tutorial you can learn how to get common values from 2 lists or ranges in Google Sheets using FILTER, MATCH, ISNUMBER, ARRAYFORMULA, SPLIT, JOIN, TRIM functions.