hlookup2

HLOOKUP, INDEX & MATCH OR VBA

Crispo Mwangi | 8-Oct-16 | 3 Comments

Having done a series on Verticle lookup  it is only fair to touch on 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 Horizontal lookup. For example, […]

REVERSE LOOKUP

REVERSE LOOKUP USING VBA

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

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 lookup the date, time and Jobs assigned to Joy Bell Go to Developer→Visual BAsic→Insert […]