Formula

There are many methods to lookup case sensitive match, but in this article we will discuss array function with INDEX MATCH with EXACT function. In the below table, same name Deep Singh is repeated with small case. If we apply Vlookup formula, in both cases it will return first match without considering the case sensitivity. … Read more

Can VLOOKUP check multiple criteria to match the value like SUMIFS or COUNTIFS ? The answer may be no, because by default the VLOOKUP function can check only one criteria for matching. But in case if you want to use VLOOKUP to match more than one conditions, this article will explain you the different ways … Read more

VLOOKUP function will search for the value in a table vertically and returns the value of the column based on the column index for matching row. The column index is defined in the formula and usually it is a constant value. With the combination of VLOOKUP MATCH function we can dynamically change the column index. … Read more

Vlookup is the most widely used function in Excel. As we all know Vlookup searches for the given value in a table and brings the value of that column or the column which is in the right side. That means by default Vlookup can look right side in the table. However with the combination of … Read more

In excel formulas; we can use the wildcard for partial matches to get the results. This can be used many functions where we do matching to get the results. Similarly, we can use the wildcard in vlookup formula. In this post I will explain you how to use vlookup wildcard in excel formula. You can … Read more

With the combination of Vlookup and Indirect functions, you can dynamically change the sheet name in the formula to Vlookup multiple sheets with same formula. How to use Vlookup multiple sheets with Indirect In VLOOKUP Function you can search the given value from a table and give the output for matching value. In case if … Read more