Excel Is Fun

Excel Magic Trick 1302

June 29, 2017 0

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

Lookup & Reference Functions

VLOOKUP and HLOOKUP

October 2, 2015 0

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

Excel Is Fun

Highline Excel 2013 Class Video 18

February 17, 2015 0

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