Academy

List of Excel function translations from English to Dutch for if you’re familiar with the English version of Excel and you have to work with the Dutch version.

HLOOKUP is a function that makes Excel search for a certain value in a row (the so called ‘table array’), in order to return a value from a different row in the same column.

VLOOKUP is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.

The IF function in Excel performs a logical comparison between two values. The result of the IF function is either TRUE or FALSE.

In this article we’ll look at three common error messages in VBA: why they appear, and how to fix them.

Whenever possible, keep your Excel formulas short and simple. Long formulas are harder to read, harder to understand, difficult to check and tough to improve.