Excel Lookup Cheat Sheet
XLOOKUP, INDEX/MATCH, COUNTIF existence checks and last-match patterns.
Existence
=COUNTIF(range,key)>0Lookup
=XLOOKUP(key,lookup,return,"Missing")Multi-sum
=SUMIFS(sum,range1,c1,range2,c2)Clean
=TRIM(CLEAN(A2))Unique
=UNIQUE(A2:A500)Filter
=FILTER(A2:D500,D2:D500="Open")Use the pattern, then verify the result
Cheat sheets are reminders, not substitutes for checking keys, data types, duplicates and edge cases. Follow the linked learning material when a pattern is new to you.