Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, …

Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, …

Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate strings and …

The value returned corresponds to the location where search_key is found in search_range. This range must be only a single row or column and should not be used if using the …

Search and use find and replace You can find and replace words in a document, spreadsheet, or presentation with Google Docs, Sheets, and Slides. You can also search within a file using the …

Use the AI function in Google Sheets Important: This feature requires an eligible Google Workspace or Google AI plan. Learn about Gemini features and plans. You can use the AI …

The range needs to be sorted in ascending order first. -2 is to search through the range with binary search. The range needs to be sorted in descending order first. Examples Lookup table …

Cross lookup. Returns the values in the data column at the position where a match was found in the search column. =XLOOKUP ("Apple",table_name!fruit,table_name!price) XLOOKUP …

Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, …

Use the AI function in Google Sheets (Workspace Labs) Important: This article refers to Google Workspace Labs, which is a trusted tester program for users to try new AI features. To check if …