This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.

This example teaches you how to lookup a value in a two-dimensional range.

The VLOOKUP function is one of the most popular functions in Excel.

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

Use the INDIRECT function in Excel to convert a text string into a valid reference.

The VLOOKUP function only looks to the right.

This example teaches you how to find the cell address of the maximum value in a column.

To compare two columns, use the IF, ISERROR and the MATCH function in Excel.

By default, the VLOOKUP function performs a case-insensitive lookup.

To find the closest match to a target value in a data column, use the INDEX, MATCH, ABS and the MIN function in Excel.