You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

You can set a print area in Google Sheets to print selected cells or sheets. The print area is how much of your spreadsheet will be printed.