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.

To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.

Last month, Google Sheets picked up additional Gemini functionality, gaining the ability call on Google’s AI to do things like explain how formulas work and automatically correct errors in formatting.

Instead of manually calculating totals, copying and pasting data, or typing in data rather than importing it, use formulas to save a ton of time and energy. To use any of the formulas mentioned here, ...