Category: Formulas

Index-Match Combination

We all love and use Vlookup Function very much. It is a great way to find and fetch values from big lists easily. But Vlookup...

Excel Tip: Excel Wildcard Characters

Are you looking for certain items that share last 3 characters? Are you not certain that the name you are searching for is Anna or...

Excel Date Functions

As we all know by now, there are several functions in excel for handling date values. But they don’t seem much useful at first sight....

IF AND OR Function Combinations

Do you need to use a logical condition in your formulas? Do you need functions like between but can’t find it? This post will show...

HLOOKUP Function

Do you need to fetch certain values from a list searching horizontally? Than HLOOKUP function is for you.