## Excel VLOOKUP Function

VLOOKP Function in Excel (with examples), using Exact and Approximate Matches, Error (#N/A) handling, …     Related Links: 1. Left Lookup with VLookup Excel function. 2. Left Lookup, with Index, Match & Offset Excel Functions. 3. Vlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup Value. 4. Case Sensitive Vlookup; Finding...

## Excel SUMPRODUCT Function

Using SUMPRODUCT FUNCTION Using  double unary minus (–)  n SUMPRODUCT Function -> A significant use   ————————————————————————————————————————————————————   Excel SUMPRODUCT Function:   The SUMPRODUCT function multiplies corresponding items of two or more arrays and then sums up these products.   Syntax: SUMPRODUCT(array1, array2, … array255)   1. array1, array2, … array255 are arrays whose...

## Excel OFFSET Function

Using the Excel OFFSET Function, with Examples   ——————————————————————————————————————————   OFFSET Function: The excel OFFSET function returns a range, which is offset by a specified number of rows and columns from a reference range.   Syntax: OFFSET(reference_range, rows, columns, height, width)   1. reference_range is a single cell or a range of adjacent cells...

## Excel INDIRECT Function

Excel INDIRECT Function, with Examples:   —————————————————————————————————————————–   Excel INDIRECT Function: The INDIRECT function returns the result of a specified reference.   Syntax: INDIRECT(text_reference, reference_type)   1. text_reference is a reference to a cell and that cell can contain: (i) an A1-style reference; (ii) an R1C1-style reference; (iii) a named range;  or (iv) a...

## Excel IF Function and IF Statements

Excel IF Function and IF Statements, with Examples     Related Link: If…Then…Else Statements (VBA).   ————————————————————————————————————————   Excel IF Function: The IF function is used to test if a condition is True or False. If a specified condition evaluates to TRUE, the IF function returns one value, and if the condition evaluates to...

## CHOOSE Function in Excel

CHOOSE Function in Excel and its uses, make Vlookup Look Left & Find Date of Next Monday with CHOOSE function. Related Links: VLOOKUP formula that looks left instead of right. ————————————————————————————————————————– Excel CHOOSE Function The CHOOSE function returns a value from a list of values based on a specified position number.   Syntax: CHOOSE(position_number,...

## Excel Text and String Functions: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE

Excel Text and String Functions:   Excel Functions for Finding and Replacing Text, with Examples: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE Related Links: 1. Excel Text and String Functions: TRIM & CLEAN. 2. Excel CODE & CHAR functions. ————————————————————————————————————————- This section deals with the Excel Worksheet String Functions – click here for detailed...

## Excel Text and String Functions: TRIM & CLEAN

Excel Text and String Functions: Removing spaces and nonprinting characters from text: Excel TRIM & CLEAN functions Related Links: 1. ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code. 2. Excel CODE & CHAR functions. 3. Excel Text and String Functions: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE. When you import data into...

## Excel CODE & CHAR Functions, VBA Asc & Chr Functions

Excel Text and String Functions: Excel CODE & CHAR Functions, VBA Asc & Chr Functions, with examples. Related Links: 1. Using VBA Chr and Asc functions to convert excel column number to corresponding column letter, and column letter to column number. 2. ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code. 3. Excel Text...

## ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code.

ASCII Code, Extended ASCII characters (8-bit system) and ANSI Code Related Links: 1. VBA Chr & Asc functions explained; corresponding Excel CHAR and CODE functions. 2. Excel Text and String Functions: TRIM & CLEAN. A ‘character set‘ maps characters to their identifying code values. Unicode is a global standard for character encoding and is the...

Scroll to top