# Excel Function

## Create a macro in Excel to sum a column

How to create a macro in Excel in 3 easy steps. The macro sums a column of values which can be set dynamically by referring to range using the INDIRECT() function. This method also shows how to use a dynamic formula which reads a value from the cell above the current cell.

## Excel INDIRECT function with INDEX MATCH

Worked example on how to use Excel INDIRECT INDEX MATCH combined, including syntax for INDIRECT and INDEX MATCH.

## Excel INDIRECT function

How to use Excel’s INDIRECT function to refer to cells using the values entered into another cell. We show the basic method of how it works, and a more advanced example to refer to content in other worksheets.

## Excel LAMBDA functions

How to create and use Excel Lambda functions in Excel 365

## Nested IFs in Excel

How to write an IF statement in Excel, and nest IF statements to test for multiple conditions. Key tips and rules about IFs and nested IFs in Excel.

## Excel IFERROR then blank; IFERROR VLOOKUP

Excel’s IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message. Examples with syntax showing IFERROR then blank, IFERROR with VLOOKUP, IFERROR then perform another function.

## EVALUATE FORMULA in Excel to find errors

How to find errors in a complex formula, step by step, using Excel’s EVALUATE FORMULA function. Where to find the command, method, worked example, and related topics.

## Sum values if cells contain specific text in Excel

How to search a range of cells for specific text, and then sum another range of cells based on the search results. Worked examples using a combination of ISNUMBER, SEARCH, SUMPRODUCT, SUMIF.

## Conditional formatting: highlight dates in current week

How to apply conditional formatting based on dates that fall in the current week. Syntax and example using a Gantt chart and weekly tasks.

## VLOOKUP MATCH two-way lookup in Excel

How to use Excel’s VLOOKUP MATCH functions to find values based on row and column lookups. The MATCH function offers several ways to create dynamic lookups, which can be easily copied across a range of cells in a worksheet.