XLFN

_xlfn xlookup excel 2016

The XLFN prefix in Excel formulas indicates that the current Microsoft Excel version does not support the given function. If you open a workbook that you created an earlier Excel version, some formulas may show an _xlfn prefix at the starting position of the function. The prefix is an alert, and Excel will indicate that … Read more

Excel XOR function

excel xor function

The Excel XOR function returns a logical “exclusive OR” of all arguments and provides TRUE or FALSE output. If you use two logical tests, XOR will return TRUE if either logical test evaluates to TRUE and return FALSE if both logical values are TRUE. XOR returns FALSE if neither logical is TRUE. Syntax, Arguments, and … Read more

Excel OR Function

Excel OR function

The Excel OR Function returns TRUE if at least one logical test is evaluated to TRUE and returns FALSE if all logical tests are FALSE. This tutorial is a part of our definitive guide about Excel functions. For example, to apply a logical test B2 for either “blue” or “yellow”, use: You can use the … Read more

Excel TOCOL Function

Excel TOCOL function

The TOCOL function flattens an array or range into a single column. By default, keep all values and scan left to right. The function allows for the functionality we were missing from FLATTEN function and works even more smoothly. Until now, there was no native FLATTEN function support in Microsoft Excel; it was available only … Read more

NOT function

excel not function

The Excel NOT function returns a reversed boolean value of a given logical or boolean value. NOT converts TRUE to FALSE and vice verse. Syntax and arguments, return value The syntax is simple: Argument: The function uses one argument: “Logical”, the value that the function will convert to TRUE or FALSE. Make sure you use … Read more

IFS Function

IFS function example

The Excel IFS function performs multiple logical tests and allows you to create shorter, easy-to-read formulas. In this tutorial – from the ground up, we will show you how the function works through practical examples. What is the IFS function in Excel? Excel IFS function can run multiple tests and return the user-defined value when … Read more

IF Function

excel if function

The Excel IF function uses a logical test and returns two values, one result for TRUE and another for FALSE. Use the IF function to perform a logical test and the greater than logical operator to check the condition. For example, if the value in cell A1 is greater than 100, the result is TRUE; … Read more

Why XLOOKUP is not working properly

why xlookup is not working in excel

When the XLOOKUP is not working with your Excel version, please read our guide, and check the possible workaround and fixes. XLOOKUP provides almost endless possibilities in Microsoft Excel. But the function in some circumstances brings difficulties. Take a closer look at the list below! 15 Reasons why XLOOKUP is Not Working Here are the … Read more

Excel UNIQUE function

Excel UNIQUE function

The Excel UNIQUE function extracts unique values from a range and returns a list of unique values in a list or range. In a nutshell: The UNIQUE function can handle various data types. For example, you can use text, numbers, and date values and returns an array of unique values. The function is available for … Read more

XLOOKUP case sensitive

xlookup case sensitive

Learn how to construct a case-sensitive exact match by combining the XLOOKUP and EXACT functions. The XLOOKUP function is not case-sensitive by default. We will use “Bob” as a lookup value in the example. XLOOKUP returns with “BOB,” which does not meet our criteria. So, if you want to construct a case-sensitive lookup, you need … Read more

FILTER Function

EXCEL FILTER function

The Excel FILTER function filters range with given criteria and extracts matching records from an array of filtered values. FILTER is one of the dynamic array functions available in Microsoft 365. Syntax and Arguments Syntax: =FILTER(array, include, [if_empty]) Arguments: array: the range or array that contains the data for filter include: the criteria array if_empty: … Read more

HLOOKUP Function

Excel HLOOKUP function tutorial and examples

The Excel HLOOKUP function searches for a certain value in a row and returns a value from a different row in the same column. Tip: If you are using Excel for Microsoft 365, try the XLOOKUP function, an improved version of Excel lookup functions that work in any direction and return exact matches by default … Read more

TRUE Function

excel true function

The Excel TRUE function returns the Boolean value TRUE. The function provides compatibility with other spreadsheet programs. In most cases, it is not necessary to use the TRUE function if you are working in Excel. The function’s only purpose is to generate the logical value TRUE. Syntax, Arguments The syntax is simple, and the TRUE() … Read more

SWITCH Function

excel switch function

The Excel SWITCH function evaluates an expression against a list of values and returns a result corresponding to the first matching value. If there is no match, SWITCH returns an optional, user-defined value. Syntax, Arguments, return value The SWITCH function matches multiple values, returns the first match, and is appeared in Excel 2019. Syntax: =SWITCH … Read more

IFERROR Function

excel iferror function

The Excel IFERROR function returns a user-defined, custom value when the embedded formula generates an error. Otherwise, it returns the standard formula result. Using IFERROR is an effective method to identify and handle formula errors. However, you must use more complex statements (for example, the IF function) without error-handling functions. The purpose of using IFERROR … Read more

TODAY Function

today function excel examples

The Excel TODAY function returns the current date and auto-updates the value when changing or opening the Workbook. Syntax and Arguments The syntax is simple: =TODAY() The function does not use argument. Using the TODAY function in Excel The TODAY function gets the current date and returns the standard Excel date as a serial number … Read more