VLOOKUP

VLOOKUP This quick video explains how to use the VLOOKUP Function in Excel. The VLOOKUP function is one of the most widely used functions in Excel and is regularly used incorrectly. Learn why it is so useful and what errors to avoid. V is short for Vertical and lets...

HLOOKUP

HLOOKUP This quick video explains how to use the HLOOKUP Function in Excel. The HLOOKUP function is widely used to lookup values horizontally in an range of cells. Learn how to use it to find matches in columns on a worksheet [et_social_follow icon_style="slide"...

The Choose Function, the Alternative to the IF or Vlookup

The Choose Function, the Alternative to the IF or Vlookup The Choose function is categorized in the latest versions of Excel as a Lookup and Reference formula, it returns a value from a set list of arguments based on a given position. The function looks as follows:...