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