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.