Excel tutorials

New to Excel? These step-by-step guides use simple examples to help you look up information, combine worksheets, and clean up repeated data.

Want a guided sequence from basic lookups to multiple conditions? Follow the Excel lookup learning path.

• Excel lookup learning path

  Follow a structured series of lessons covering VLOOKUP, XLOOKUP, INDEX and MATCH, and multi-criteria lookups.

• How to use MATCH in Excel

  Find where an item appears in a list. See how to ask Excel for an exact match.

• How to use LOOKUP in Excel

  Find a value in a sorted list and return the related result, such as a price tier.

• How to use INDEX in Excel

  Return a value from a table by its position, then combine INDEX with MATCH to find information by name.

• How to use VLOOKUP in Excel

  Find an item in the first column of a table and return a related value from another column.

• How to use XLOOKUP in Excel

  Look up a value and return a result from a separate range, with a message for items that are not found.

• How to use IFERROR in Excel

  Return a clear alternative when a formula produces an error, including a lookup that cannot find a match.

• How to use SUMIFS in Excel

  Add values that meet one or more criteria, such as total sales for a selected name and department.

• How to use COUNTIFS in Excel

  Count rows that meet multiple conditions, such as records matching a name and department.

• How to merge two Excel sheets

  Choose the right method to combine lists or bring matching details into one worksheet.

• How to remove duplicates in Excel

  Find repeated rows, remove duplicates safely, or highlight them before making changes.

Which function should I use?

Use MATCH to find an item's place in a list. Use INDEX to get the value at a position. Use VLOOKUP or XLOOKUP to find a value and return related information. Use LOOKUP for approximate matches in sorted data. If you want to match two files without writing a formula, try the Excel Lookup matching tool.