How it works
Get ready-to-edit examples of common Excel formulas with the separator used by your regional settings. It is a shortcut for lookup, unique-list and duplicate checks.
Excel & CSV
Excel formula examples
Ready-to-edit XLOOKUP, UNIQUE and duplicate-check formulas.
Result
0 characters
Excel & CSV
How it works: Excel formula examples
Get ready-to-edit examples of common Excel formulas with the separator used by your regional settings. It is a shortcut for lookup, unique-list and duplicate checks.
Input → Result
Input
Excel formula examples
Result
=IFERROR(XLOOKUP(A2,Sheet2!A:A,Sheet2!B:B,""),"")
Common uses
- Start an XLOOKUP without remembering every argument
- Create a unique filtered list
- Flag duplicate values in a column