Categories
Excel glossary
A comprehensive glossary of Excel-related terms is an invaluable resource for users at all levels, from beginners to advanced professionals. Excel, with its extensive array of functions, features, and terminology, can sometimes be overwhelming. This glossary aims to demystify the language of Excel by providing clear, concise definitions of common terms and concepts.
XLOOKUP: the debate is over
XLOOKUP is the newest lookup function in Excel. It joins INDEX & MATCH, VLOOKUP, and HLOOKUP as the newest weapon in the arsenal of formulas used to masterfully locate and supply data across models.
How to use HLOOKUP in Excel
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
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.
What is an array formula
An array formula allows you to perform multiple calculations at once, or, it can perform one or more calculations multiple times within a selected cell range.
What is a circular reference
A circular reference refers to a formula, that visits its own or another cell more than once in its chain of calculations, creating an infinite loop which slows down your spreadsheet significantly.