/Array-ifyLookupFormula
Turn into a single dynamic array formula a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.
Spreadsheetsadvanced#lookup#vlookup
Formulas
60 commands
/ConvertCrossSheetReference
Convert between spreadsheet dialects for a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.
Spreadsheetsmedium#cross-sheet#reference
/SimplifyTextParsingFormula
Simplify an overly complex a text parsing/extraction formula — e.g. splitting a full name column into first and last name.
Spreadsheetseasy#text#parsing
/DebugPivotTableSetup
Find and fix the error in a pivot table configuration — e.g. summarizing sales by rep and quarter.
Spreadsheetsadvanced#pivot-table#summary
/Array-ifyErrorHandlingFormula
Turn into a single dynamic array formula an error-handling formula — e.g. a lookup that shows blank instead of #N/A when nothing.
Spreadsheetsmedium#error-handling#iferror
/ExplainArrayFormula
Explain in plain terms how an array or dynamic-array formula — e.g. summing sales for every unique product in one formula.
Spreadsheetseasy#array-formula#dynamic-array
/ConvertConditionalFormattingRule
Convert between spreadsheet dialects for a conditional formatting rule — e.g. highlighting overdue invoices in red.
Spreadsheetsadvanced#conditional-formatting#visual
/DebugValidationRule
Find and fix the error in a data validation rule — e.g. restricting a column to only approved status values.
Spreadsheetsmedium#data-validation#rules
/WriteNestedIfChain
Write the right formula for a deeply nested IF statement — e.g. grading students into five tiers based on score.
Spreadsheetseasy#if#nested
/Array-ifyDateCalculation
Turn into a single dynamic array formula a date/time calculation — e.g. calculating business days until a project deadline.
Spreadsheetsadvanced#dates#time
/ExplainLookupFormula
Explain in plain terms how a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.
Spreadsheetsmedium#lookup#vlookup
/SimplifyCrossSheetReference
Simplify an overly complex a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.
Spreadsheetseasy#cross-sheet#reference
/DebugTextParsingFormula
Find and fix the error in a text parsing/extraction formula — e.g. splitting a full name column into first and last name.
Spreadsheetsadvanced#text#parsing
/WritePivotTableSetup
Write the right formula for a pivot table configuration — e.g. summarizing sales by rep and quarter.
Spreadsheetsmedium#pivot-table#summary
/ExplainErrorHandlingFormula
Explain in plain terms how an error-handling formula — e.g. a lookup that shows blank instead of #N/A when nothing.
Spreadsheetseasy#error-handling#iferror
/ConvertArrayFormula
Convert between spreadsheet dialects for an array or dynamic-array formula — e.g. summing sales for every unique product in one formula.
Spreadsheetsadvanced#array-formula#dynamic-array
/SimplifyConditionalFormattingRule
Simplify an overly complex a conditional formatting rule — e.g. highlighting overdue invoices in red.
Spreadsheetsmedium#conditional-formatting#visual
/WriteValidationRule
Write the right formula for a data validation rule — e.g. restricting a column to only approved status values.
Spreadsheetseasy#data-validation#rules
/Array-ifyNestedIfChain
Turn into a single dynamic array formula a deeply nested IF statement — e.g. grading students into five tiers based on score.
Spreadsheetsadvanced#if#nested
/ExplainDateCalculation
Explain in plain terms how a date/time calculation — e.g. calculating business days until a project deadline.
Spreadsheetsmedium#dates#time
/ConvertLookupFormula
Convert between spreadsheet dialects for a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.
Spreadsheetseasy#lookup#vlookup
/DebugCrossSheetReference
Find and fix the error in a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.
Spreadsheetsadvanced#cross-sheet#reference
/WriteTextParsingFormula
Write the right formula for a text parsing/extraction formula — e.g. splitting a full name column into first and last name.
Spreadsheetsmedium#text#parsing
/Array-ifyPivotTableSetup
Turn into a single dynamic array formula a pivot table configuration — e.g. summarizing sales by rep and quarter.
Spreadsheetseasy#pivot-table#summary
/ConvertErrorHandlingFormula
Convert between spreadsheet dialects for an error-handling formula — e.g. a lookup that shows blank instead of #N/A when nothing.
Spreadsheetsadvanced#error-handling#iferror
/SimplifyArrayFormula
Simplify an overly complex an array or dynamic-array formula — e.g. summing sales for every unique product in one formula.
Spreadsheetsmedium#array-formula#dynamic-array
/DebugConditionalFormattingRule
Find and fix the error in a conditional formatting rule — e.g. highlighting overdue invoices in red.
Spreadsheetseasy#conditional-formatting#visual
/Array-ifyValidationRule
Turn into a single dynamic array formula a data validation rule — e.g. restricting a column to only approved status values.
Spreadsheetsadvanced#data-validation#rules
/ExplainNestedIfChain
Explain in plain terms how a deeply nested IF statement — e.g. grading students into five tiers based on score.
Spreadsheetsmedium#if#nested
/ConvertDateCalculation
Convert between spreadsheet dialects for a date/time calculation — e.g. calculating business days until a project deadline.
Spreadsheetseasy#dates#time
/SimplifyLookupFormula
Simplify an overly complex a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.
Spreadsheetsadvanced#lookup#vlookup
/WriteCrossSheetReference
Write the right formula for a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.
Spreadsheetsmedium#cross-sheet#reference
/Array-ifyTextParsingFormula
Turn into a single dynamic array formula a text parsing/extraction formula — e.g. splitting a full name column into first and last name.
Spreadsheetseasy#text#parsing
/ExplainPivotTableSetup
Explain in plain terms how a pivot table configuration — e.g. summarizing sales by rep and quarter.
Spreadsheetsadvanced#pivot-table#summary
/SimplifyErrorHandlingFormula
Simplify an overly complex an error-handling formula — e.g. a lookup that shows blank instead of #N/A when nothing.
Spreadsheetsmedium#error-handling#iferror
/DebugArrayFormula
Find and fix the error in an array or dynamic-array formula — e.g. summing sales for every unique product in one formula.
Spreadsheetseasy#array-formula#dynamic-array
/WriteConditionalFormattingRule
Write the right formula for a conditional formatting rule — e.g. highlighting overdue invoices in red.
Spreadsheetsadvanced#conditional-formatting#visual
/ExplainValidationRule
Explain in plain terms how a data validation rule — e.g. restricting a column to only approved status values.
Spreadsheetsmedium#data-validation#rules
/ConvertNestedIfChain
Convert between spreadsheet dialects for a deeply nested IF statement — e.g. grading students into five tiers based on score.
Spreadsheetseasy#if#nested
/SimplifyDateCalculation
Simplify an overly complex a date/time calculation — e.g. calculating business days until a project deadline.
Spreadsheetsadvanced#dates#time
/DebugLookupFormula
Find and fix the error in a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.
Spreadsheetsmedium#lookup#vlookup
/Array-ifyCrossSheetReference
Turn into a single dynamic array formula a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.
Spreadsheetseasy#cross-sheet#reference
/ExplainTextParsingFormula
Explain in plain terms how a text parsing/extraction formula — e.g. splitting a full name column into first and last name.
Spreadsheetsadvanced#text#parsing
/ConvertPivotTableSetup
Convert between spreadsheet dialects for a pivot table configuration — e.g. summarizing sales by rep and quarter.
Spreadsheetsmedium#pivot-table#summary
/DebugErrorHandlingFormula
Find and fix the error in an error-handling formula — e.g. a lookup that shows blank instead of #N/A when nothing.
Spreadsheetseasy#error-handling#iferror
/WriteArrayFormula
Write the right formula for an array or dynamic-array formula — e.g. summing sales for every unique product in one formula.
Spreadsheetsadvanced#array-formula#dynamic-array
/Array-ifyConditionalFormattingRule
Turn into a single dynamic array formula a conditional formatting rule — e.g. highlighting overdue invoices in red.
Spreadsheetsmedium#conditional-formatting#visual
/ConvertValidationRule
Convert between spreadsheet dialects for a data validation rule — e.g. restricting a column to only approved status values.
Spreadsheetseasy#data-validation#rules
/SimplifyNestedIfChain
Simplify an overly complex a deeply nested IF statement — e.g. grading students into five tiers based on score.
Spreadsheetsadvanced#if#nested
/DebugDateCalculation
Find and fix the error in a date/time calculation — e.g. calculating business days until a project deadline.
Spreadsheetsmedium#dates#time
/WriteLookupFormula
Write the right formula for a lookup formula (VLOOKUP/XLOOKUP) — e.g. matching product IDs to prices across two sheets.
Spreadsheetseasy#lookup#vlookup
/ExplainCrossSheetReference
Explain in plain terms how a cross-sheet reference formula — e.g. pulling totals from twelve monthly tabs into a summary tab.
Spreadsheetsadvanced#cross-sheet#reference
/ConvertTextParsingFormula
Convert between spreadsheet dialects for a text parsing/extraction formula — e.g. splitting a full name column into first and last name.
Spreadsheetsmedium#text#parsing
/SimplifyPivotTableSetup
Simplify an overly complex a pivot table configuration — e.g. summarizing sales by rep and quarter.
Spreadsheetseasy#pivot-table#summary
/WriteErrorHandlingFormula
Write the right formula for an error-handling formula — e.g. a lookup that shows blank instead of #N/A when nothing.
Spreadsheetsadvanced#error-handling#iferror
/Array-ifyArrayFormula
Turn into a single dynamic array formula an array or dynamic-array formula — e.g. summing sales for every unique product in one formula.
Spreadsheetsmedium#array-formula#dynamic-array
/ExplainConditionalFormattingRule
Explain in plain terms how a conditional formatting rule — e.g. highlighting overdue invoices in red.
Spreadsheetseasy#conditional-formatting#visual
/SimplifyValidationRule
Simplify an overly complex a data validation rule — e.g. restricting a column to only approved status values.
Spreadsheetsadvanced#data-validation#rules
/DebugNestedIfChain
Find and fix the error in a deeply nested IF statement — e.g. grading students into five tiers based on score.
Spreadsheetsmedium#if#nested
/WriteDateCalculation
Write the right formula for a date/time calculation — e.g. calculating business days until a project deadline.
Spreadsheetseasy#dates#time