7 ALTERNATIVES TO NESTED IF FUNCTION

7 ALTERNATIVES TO NESTED IF FUNCTION

IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all programming and Excel formulae mastery.  However, it is also one of the most misused functions, especially Nested IF. Especially now with Excel 2007 and beyond, you can...
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...

Pin It on Pinterest