Academy
The PerfectXL Academy is a knowledge base with articles on various topics related to Excel. Here, you will find everything you want to know and learn about Excel, from a simple glossary to detailed instructions. Are you missing any topics? We’d love to hear your suggestions!
Dutch to English
List of Excel function translations from Dutch to English for if you’re familiar with the Dutch version of Excel and you have to work with the English version.
English to Dutch
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.
Excel HLOOKUP Function: Syntax, Examples & How to Use It
HLOOKUP is a powerful Excel function that helps you search for a specific value across a row (called the ‘table array’) and retrieve data from another row in the same column. HLOOKUP stands for ‘Horizontal Lookup’ and is essential for anyone looking to streamline data searches in Excel.
VLOOKUP
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.
IF
The IF function in Excel performs a logical comparison between two values. The result of the IF function is either TRUE or FALSE.
Never struggle with these errors in VBA again
In this article we’ll look at three common error messages in VBA: why they appear, and how to fix them.