Excel Is Fun

Excel Magic Trick 1302

DESCRIPTION Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel [Read More >>>]

Lookup & Reference Functions

VLOOKUP and HLOOKUP

VLOOKUP function VLOOKUP is one of the lookup and reference functions you can use when you need to find things in a table or a range by row. For example, look up an employee’s last [Read More >>>]

Excel Is Fun

Highline Excel 2013 Class Video 18

DESCRIPTION Topics in this video: (00:38) Why do we have to know lookup functions? (03:44) VLOOKUP, Exact Match. VLOOKUP delivers a value to the cell. (08:34) What happens if lookup value is not in your [Read More >>>]