How to use Tax Rates in Excel
Nov 06, 2020
This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.
How to use Two-way Lookup in Excel
Nov 06, 2020
This example teaches you how to lookup a value in a two-dimensional range.
How to use Vlookup function in Excel
Nov 06, 2020
The VLOOKUP function is one of the most popular functions in Excel.
How to use Offset function In Excel
Nov 04, 2020
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.
How to use Indirect In Excel
Oct 31, 2020
Use the INDIRECT function in Excel to convert a text string into a valid reference.
How to Use Left Lookup function In Excel
Oct 31, 2020
The VLOOKUP function only looks to the right.
How to Use Locate Maximum Value In Excel
Oct 31, 2020
This example teaches you how to find the cell address of the maximum value in a column.
How to Compare Two Columns in Excel
Oct 28, 2020
To compare two columns, use the IF, ISERROR and the MATCH function in Excel.
How To Create a Case Sensitive Lookup In Excel
Oct 28, 2020
By default, the VLOOKUP function performs a case-insensitive lookup.
How to Use VLOOKUP function find Closest Match In Excel
Oct 28, 2020
To find the closest match to a target value in a data column, use the INDEX, MATCH, ABS and the MIN function in Excel.