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

First, you need to identify the Google Sheet document from which you want to embed data from in another sheet, and grab the url.

VLOOKUP, one of the most useful Microsoft Excel functions, is also available on Google Sheets. Here's how to use VLOOKUP to sift through Sheets data.