# Advanced Excel Formula

## Using VLOOKUP Formula in Excel effectively using MATCH Worksheet function

In my earlier Excel tutorial post, we have learned how to use vlookup function. In this post, I will show you simple tweak through which you can make VLOOKUP function more effective. This will be useful for you when you want to map huge data. For example you have base table with more than 20 or [...]

## Excel Formula to return the last nonblank cell in a column or Row

Some times in Excel worksheet which we update frequently by adding new data to its columns and we need to reference the last value in a particular column. That is the value most frequently entered. We can achieve this combining two excel worksheet formulas COUNTA and INDEX. The source of this tips is John Walkenbach’s [...]

## How to Perform two column Lookup on Excel

In earlier post, we have seen how to use simple vlookup on Excel, two way lookup comparing row and column  This post will show you how perform lookup comparing two column in Excel.  To perform lookup based on two column can be achieved in two ways. first one by concatenating two columns and the using vlookup [...]

## Excel formula to count the Characters in cell based on different criteria

There is a direct Excel formula to count the number of characters in a cell. However, we some times come under a situations where we need to count a specific character in a cell or a occurrence of a substring in a cell.  Here is the steps to achieve these requirements.Counting all the characters in a Cell: To count the number [...]

## Different ways of using Single Criterion SUM function in Excel

We have already seen the basic syntax and how to use single criteria SUM in Excel. In this post, we will see how use conditional sum based on difference scenarios. For detailed explanation on SUMIF function please read here. Examples for Using conditional sum Excel Function SUMIF: Below are the some of the Excel example [...]

## Using VLOOKUP on Excel-Explained with Syntax and Examples

VLOOKUP functions of excel is very useful when you need to return a value from a table or a range of cells by looking up another value. VLOOKUP on excel can be used for finding the value in a range which are present in the other range in the same sheet or other sheet and [...]

1 2 3