Usage & tips

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 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.