Stop typos and inconsistent entries. Learn how to add a drop-down list in Excel with data validation, in four steps.

Learn INDEX MATCH in Excel step by step: look up to the left, avoid #N/A errors, and know when to use it instead of VLOOKUP or XLOOKUP.