You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
Google has rolled out an update to Gemini in Sheets that allows the AI to understand and analyze data from multiple tables.
To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.