7 Reasons Why XLOOKUP function is Superior to VLOOKUP function and INDEX+MATCH combo
XLOOKUP Function against VLOOKUP and INDEX+MATCH
Category: Excel Functions
Functions in Excel
LOOKUP Function
Name of the Function LOOKUP Type of Function Lookup and reference functions Purpose Lookup a value in a single row/column and return the corresponding value from the second row/column Syntax (lookup_value, lookup_vector, [result_vector]) Argument 1 (required) lookup_value – The value LOOKUP searches for in the first vector. This can be a number, text, a logical…
COUNT Function
Name of the Function COUNT Type of Function Statistical Purpose return the count of numbers present in a data range/ranges, arrays etc. Syntax =COUNT (value1, [value2], …) Argument 1 (required) value1 – An item, cell reference, or range Argument 2 (optional) value2 – An item, cell reference, or range Return Value a number representing the…
CONCATENATE Function
Name of the Function CONCATENATE Type of Function Text Purpose Join two or more strings into one Syntax CONCATENATE(text1, [text2], …) Argument 1 (required) The first item to join. The item can be a text value, number, or cell reference Argument 2 (optional) Additional text items to join Return Value Text joined together The CONCATENATE…