HLOOKUP, INDEX & MATCH OR VBA

HLOOKUP, INDEX & MATCH OR VBA

Having done a series on Verticle lookup, it is only fair to touch on the Horizontal lookup. HLOOKUP function is the most popular function for this kind of lookup but it has a number of limitations and thus one may need to know a few other ways you can carry out a...
REVERSE LOOKUP USING VBA

REVERSE LOOKUP USING VBA

This is the last article in the series of reverse lookup in excel. Unless you are already versed with Reverse Lookup, consider checking below 2 articles first; Reverse Lookup & Reverse Lookup with duplicates Now using VBA we are going to look up the date, time and...
REVERSE LOOKUP IN EXCEL

REVERSE LOOKUP IN EXCEL

In my research and tutoring excel, I have found that many people find the Reverse lookup concept to be among the top 10 complicated things in excel. This article hopes to shed more light than heat in demystifying the Reverse Lookup in excel. In the normal lookup, we...
2 WAY LOOKUP IN EXCEL

2 WAY LOOKUP IN EXCEL

The ability to lookup values is a MUST have skills for all Excel users. If you cannot lookup you cannot excel in data analysis. In this article, I will show you  5  ways you can do a 2-way lookup in Excel. 1. USING SUMPRODUCT Using below sales data lookup and sum the...