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

SUM and VLOOKUP are only a few of the functions Google Sheets offers for using mathematical formulas. When dealing with complex calculations, Apps Script can help you create a custom one. It's a ...

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.