## VLOOKUP IS DEAD–OR IS IT?

In the year 1882, a German philosopher,Â Friedrich Nietzsche made a claim that has revolutionized Philosophical and Theological discussions since then. His Claim–God is Dead. There has been a similar discussion in the Excel world, not about God, but about...

## XLOOKUP Two-way approximate match multiple criteria

This post is inspired by Dave Bruns’s post on Two-way approximate match multiple criteria. Having read Dave’s article I thought… “Is there an easy way of doing this using XLOOKUP instead of INDEX/MATCH?” ðŸ¤” Option 1: Using IF Function...

## WTF with XLOOKUP Function

NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions Killer”, “Ultimate Lookup Function”, “Single Most Important function”,...

## Excel Flash Fill: 15 Things You Can Do In a Flash. Part 1

“Excel Flash Fill Is A Brilliant Time Saver,” writes Life hacker Australia.Â “In fact, itâ€™s so good it feels like magic,” says Tech Radar “Flash Fill brings the power of text manipulation to the hands of common, non-technical, everyday...

## 4 ways to lookup items not matching a list

There are times when you want to look up and retrieve values based on a list. Normal filtering can only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to lookup items not matching a list. For example, below we...

## 5 Ways to Lookup Unique Values in Excel

Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is to...

## 4 WAYS TO SUM DATA BY WEEK NUMBER

Every organizationÂ requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production section. Excel has a beautiful but overlooked function (WEEKNUM) that returns an integer representing the week in the year (1 to 53)....

## 7 EXCEL TABLES BEST KEPT SECRETS

When was the last time you used excel tables? Do you know how powerful excel tables are? If you have never or not recently used excel tables, it could be because you have not realized how powerful they are in data analysis. By reading below 7 excel tableâ€™s secrets,...

## 7+ WAYS TO LOOKUP NUMBER VALUES

The ability to lookup number values in excel is a must-have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup values. The more lookup function you know the better you become in retrieving numbers like...

## HLOOKUP with multiple criteria (OR/AND logic)

When was the last time you comprehensively looked at the HLOOKUP function and its alternative? To look up data horizontally, many excel users tend to use HLOOKUP but it has its limitations. So what are the alternatives? In this article,...