| Bidirectional Lookup |
XLOOKUP |
=XLOOKUP(val, lookup_col, return_col, "Not Found") |
| Multi-Condition Sum |
SUMIFS |
=SUMIFS(sum_range, crit_range1, crit1, crit_range2, crit2) |
| Multi-Condition Count |
COUNTIFS |
=COUNTIFS(crit_range1, crit1, crit_range2, crit2) |
| Multi-Condition Average |
AVERAGEIFS |
=AVERAGEIFS(avg_range, crit_range1, crit1) |
| Safe Error Handling |
IFERROR |
=IFERROR(formula, fallback_value) |
| Multi-Condition Logic |
IFS |
=IFS(cond1, val1, cond2, val2, TRUE, fallback) |
| Text Cleansing |
TRIM + PROPER |
=PROPER(TRIM(text_cell)) |
| Delimiter Joining |
TEXTJOIN |
=TEXTJOIN(", ", TRUE, text_range) |
| Dynamic Distinct List |
UNIQUE |
=UNIQUE(range_or_column) |
| In-Memory Filtering |
FILTER |
=FILTER(table, table[Status] = "Active", "None") |