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

Google's AI function brings Gemini-powered language models right into your spreadsheet cells without any add-ons. With it, you can generate fresh text, summarize blocks of data, categorize entries, or ...