SheetWorkflow Guide 
Give an Excel IF Formula Two Deliberate Outcomes
IF evaluates a logical test and returns one result when it is true and another when it is false.
Distinguish Looking Up One Value from Summing Matching Records
A lookup and a conditional total solve different Excel problems.
Set MATCH Explicitly for Exact Excel Lookups
MATCH returns a value's relative position inside a lookup range rather than the value stored in another column.
Choose Exact Matching in a Google Sheets INDEX-MATCH Lookup
MATCH searches a single row or column and returns the position of a requested value.
Use INDEX and MATCH When the Result Is to the Left
VLOOKUP expects the searched column to sit to the left of the returned information.
Retrieve an Excel Value by Its Position with INDEX
INDEX retrieves an element from a range using a specified row and column position.
Apply One Custom Calculation Across an Array with MAP
MAP processes each value in an Excel array using a calculation defined by LAMBDA.
Convert Reference Text into a Usable Excel Reference
INDIRECT allows an Excel formula to derive its cell or range reference from text.
Translate Worksheet Text Through an Online Excel Function
TRANSLATE converts text between languages using Microsoft Translation Services.
Build a Separate Results Sheet with QUERY
QUERY brings database-style selection to a Google spreadsheet.
Summarize the Same Excel Position Across Several Sheets
A three-dimensional Excel reference points to the same cell or range across multiple worksheets.
Consider IFS When Several Conditions Have a Clear Order
IFS tests conditions in order and returns the value associated with the first one that evaluates to true.
Keep Nested Excel IF Formulas Testable and Understandable
Nesting places one function inside another, allowing IF to evaluate more elaborate situations than a single comparison.
Use AND, OR, and NOT to Express the Intended Decision
IF can return different outcomes from a test, while AND, OR, and NOT describe relationships inside that test.
Choose AND or OR for a Multi-Condition Excel IF Test
An IF formula can evaluate several conditions by combining its logical test with AND or OR.
Start XLOOKUP with Separate Search and Return Ranges
XLOOKUP searches for a specified value in a range or array and returns the related information from another range.
Check COUNTIF's Range Requirement Before Building a Formula
COUNTIF counts cells meeting a specified condition, with one argument for the range and another for the criterion.
Use Comparison Symbols and Wildcards in Excel Counts
COUNTIF evaluates one criterion over a range.
Count a Repeated Inventory Label Without Summing Quantities
COUNTIF can count how often a particular label occurs within a selected range.
Check Populated Excel Cells Without Confusing Them with Rows
Excel offers several ways to count nonblank cells, including the status bar, Find and Replace, and formulas.
