# Excel Function

## INDEX and MATCH in Excel

How to combine Excel’s INDEX and MATCH functions to look up values. Syntax, examples and explanations of how to use INDEX and INDEX MATCH in Excel.

## Add time using Excel’s TIME() function

How to use Excel’s TIME function to add time to time, with a worked example to create a series of appointments.

## FORMULATEXT function in Excel – display formulas

It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.

## Excel’s CONCATENATE / CONCAT function — create a SUM(CASE WHEN) SQL statement

To join text and/or numbers together using Excel’s CONCATENATE / CONCAT function. An example is shown how to generate a a set of SUM(CASE WHEN) SQL statements.

## VLOOKUP with CONCATENATE in Excel

Look up values in a table, using Excel’s VLOOKUP with the CONCATENATE function to combine values in multiple cells for the lookup. For example, convert a long format data table to a wide format data table.

## Excel’s CHOOSE function with array

How to return an array of non-adjacent cells in Excel.

## Generate RANDOM numbers with Excel’s RANDBETWEEN function

How to use Excel’s RANDBETWEEN function to generate random numbers between two values. A short video shows how to turn the values from dynamic to static.

## Excel IFERROR function — examples: return a blank; with VLOOKUP; perform a different function

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.

## Excel IF function

To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.

## VLOOKUP Excel function – explanation and examples

How to use the VLOOKUP function in Excel