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 […]

FIND N using multiple criteria

FIND THE LAST OR Nth OCCURENCE IN EXCEL USING MULTIPLE CRITERIA

Crispo Mwangi | 3-Feb-17 | Leave a Comment

In the previous article, we looked at 7 ways to find the last or Nth occurrence in a Sorted list in excel. Unsorted list poses a challenge since you need to find the occurrence using multiple criteria. To show the different methods I have created a list of Customers and their Purchase Orders (P.O). You can download […]

FIND NTH IN EXCEL

FIND THE LAST OR Nth OCCURENCE IN EXCEL (SORTED LIST)

Crispo Mwangi | 27-Jan-17 | Leave a Comment

Finding the Nth or the Last value in a sorted or unsorted list can pose a challenge if you do not understand which functions to use. This article will show you different ways to carry out this sort of find and retrieve in a sorted list. How to handle unsorted list will be tackled in […]

Reverse lookup with duplicates

REVERSE LOOKUP WITH DUPLICATES IN EXCEL

Crispo Mwangi | 7-Sep-16 | Leave a Comment

It is good to be able to do a Reverse Lookup but it is Awesome if you know how to return Multiple Items. Before you continue with the current article, Please revist the Previous Article on reverse lookup as this is a continuation. Suppose you are managing a project and you have below scheduled dates, […]