You can use the IMPORTRANGE function in Google Sheets to easily copy data from one spreadsheet to another.
You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
Google Messages could soon get a new feature The Insights feature is reportedly found in the Google Messages beta Insights ...