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.
Cell range
A cell range in an Excel file is a selection of cells. This range is usually symmetrical (square), but can exist of separate cells just the same. You can refer to a cell range in a formula as well.
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.
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.
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.