HLOOKUP

HLOOKUP with multiple criteria (OR/AND logic)

Crispo Mwangi | 12-Aug-17 | Leave a Comment

When is the last time you comprehensively looked at 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, we shall look at? Horizontal lookup using HLOOKUP, VBA & INDEX & MATCH How to return multiple items in a Horizontal Lookup How […]

reverse LOOKUP

REVERSE LOOKUP IN EXCEL

Crispo Mwangi | 3-Sep-16 | 2 Comments

In my research and tutoring excel, I have found that many  people find 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 use the Column and/or Row header to return the value that […]

Overlooked uses MOD function

7 Overlooked Uses of Excel MOD Function

Crispo Mwangi | 7-Jun-16 | 10 Comments

In Over  450 functions in Excel, there are some powerful but highly underutilized functions and some overly popular functions too. Functions like IF, SUM, COUNT, AVERAGE are well known by all excel users. Yet there are some functions like MOD, WEEKDAY, WORKDAY, CHOOSE, DATEDIF, DELTA, SUBSTITUTE, HYPERLINK are rarely used. This is part 1 of a […]