How to Return Multiple Columns in VLOOKUP Function
By default, VLOOKUP is set to return a Single column but with a small tweak, it can return...
How to Use Multiple Criteria in a VLOOKUP function
Many users think you cannot use multiple criteria in a VLOOKUP Function, but this is wrong....
How to Initialize Multiple Middle Names In Excel
Initializing a single middle name is easy using a simple 3 steps: =LEFT(name,FIND(" ",name)) &...
How To Initialize the First and/or Second Name in Excel
Here are 4 ways to Initialize the First and/or Second Name in Excel This article is inspired...
HLOOKUP To Return Multiple Items In Excel
Of all lookup functions, HLOOKUP is among the least famous ones. It looks up a value in the first...
VLOOKUP To Return The Top N Items
VLOOKUP function is mostly underrated and assumed that it cannot return multiple items. The only...
XOR logic in Excel
Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns...
OR Logic in Excel Formula
When testing for multiple conditions, OR logic is used to determine if ANY condition in the test...
How VLOOKUP Returns Items Repeated N Times
Among many misconceptions about the VLOOKUP function is that it cannot return items repeated n...
VLOOKUP Exact Partial Match (Multiple Results)
On Default, VLOOKUP is not case sensitive thus it does not do an Exact match lookup. It is even...
How to Use What If Analysis – Goal Seek Feature
This is part 1 of the 4 part series on What if analysis. This blog will cover the Goal Seek...
101 Ways to Save Time Using Excel Fill Series
If you are not using the excel fill series in your day-to-day tasks you are wasting a lot of time...