# Formulas

## Excel Vlookup Approximate Match And Exact Match Example

In the previous article How To Use VLOOKUP In Excel, I told you how to use the excel VLOOKUP function to search for value in a cell range and return the wanted value in the cell range. In this article, I will tell you what is the difference between VLOOKUP approximate match and exact match …

## How To Use VLOOKUP In Excel

The excel VLOOKUP function can be used to search the values in the first column of the specified cell range. When it finds the value in a cell of the first column of a cell range, it will return the cell value of the specified column number in the same row. This article will tell …

## Excel Find First / Last Non-Empty Cell In Row / Column Example

In this article, I will tell you how to use the excel INDEX & MATCH function to find the first non-empty cell in a row or column, it will also tell you how to use the excel LOOKUP function to find the last non-empty cell in a row or column with examples.

## How To Show Custom Error Message When Executing Excel Formula

When you input an excel formula in excel cell and execute it, you may encounter some error message like #N/A. But this kind of error message is not readable and understandable. This article will tell you how to show customized error message to replace the default error message when the formula throw error.

## How To Use Excel Match Function With Examples

The excel MATCH function is used to find a value in a cell range, it will return the position number of the search value in the cell range. After that, we can use the excel INDEX function and the position number to get the matched cell data. This article will tell you how to use …

## How To Use Excel Index Function With Examples

The excel INDEX function is used to find a value in a specified array or one/multiple cell ranges. This article will tell you how to use the excel index function to find data with some examples.

## How To Use Excel SUMPRODUCT Formula Example

The excel function SUMPRODUCT is very useful when you want to use a formula to calculate the summary of multiple number arrays. This article will tell you how to use the excel SUMPRODUCT formula with examples.

## How To Count Cells Between Or Not Between Two Values In Excel

In this article, I will tell you how to count the number of cells in a cell range that cell value between or not between 2 values ( number or date ).

## How To Count Less Than And / Or Greater Than In Excel

In this article, I will tell you how to use the excel formula to count less than and/or greater than operations with examples.

## How To Use Excel Autosum Example

In the previous article, I told you how to use the excel SUM function to add multiple cell number values in the formula. In this article, I will tell you how to use a shortcut button ( ∑ AutoSum button ) to summarize a column or a row of cell number values quickly, easily, and …