Recent Blog Posts
How To Create Excel Drop Down List – Step by Step
Excel drop-down list is a perfect way to reduce data entry errors. Also, it speeds up data entry. It lets you create some valid choices in a drop-down [...]
Over 10 Actionable VLOOKUP Examples Explained
As we all know, the best way to learn something is to get your hand on it, make mistakes and learn from those mistakes. As they say, practice makes [...]
VLOOKUP wildcard in Excel formula (partial text match)
If you are reading this, I guess you already know how the VLOOKUP function works. This function is so sensitive that it can detect even trailing and leading spaces [...]
The three main VLOOKUP Limitations in Excel
VLOOKUP is one of the popular functions in Excel. It is very helpful to many Excel users who want to look and retrieve information from a table (or dataset). As [...]
Excel INDEX function explained (with examples)
In this step by step tutorials, you’ll learn how to use the INDEX function in Excel, with a clear syntax break down and step by step examples demystified. What [...]
Excel MATCH function explained (with examples)
What is MATCH function in Excel? The MATCH function is used to search for a value in a range in order to retrieve the position of a cell that [...]
How to do a Double lookup in Excel (Two-way lookup)
What is double lookup in Excel? Two-way lookup or double lookup is simply a formula that looks in both vertical and horizontal directions simultaneously, in order to find a [...]
VLOOKUP to the left with INDEX-MATCH
This is a step by step tutorials on how to perform VLOOKUP to the left with the INDEX-MATCH functions. VLOOKUP is very useful for finding and retrieving related information in [...]
