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, …

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 …

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 …

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 …

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 …

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 …

QUERY function Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax …

QUERY function COUNTIF VLOOKUP Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on …