When working with multiple sheets in an Excel workbook, you may need to reference data from one sheet to another for calculations, analysis, or to keep your workbook organized. Here are a couple ...

When you're ready to start searching, here's what you do: In Excel or Sheets, select an empty cell and type the name (or item number, etc) of what you want to search for.