VLOOKUP

One of Excels most powerful but sometimes overlook tools is the LOOKUP family of functions. While there are several variations, LOOKUP or HLOOKUP,