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

Google Sheets is a versatile spreadsheet app you can use across multiple platforms, including any browser as a web app, on Android or iOS as a mobile app, or even as a desktop app through ChromeOS.

Spreadsheets are supposed to save time, but sometimes they just make things messier. I hated digging through endless menus until I found a handful of formulas that do the heavy lifting for me. VLOOKUP ...