VLOOKUP function finds a value in a table or array and then return a value which is in the same row but another column
Tag: Microsoft
LOOKUP Function in Excel
Lookup function will find a user defined value in a vector and then return another value which is same position of first value in another vector with same size of first vector
AND OR function in Excel
The And function check if all statements to be true, and if so, it will return the True result, otherwise, if one of the statements be false, then it will return the False value.
The OR function check if at least one of the statements be true, if so, then it will return the True value. Otherwise, if all of the statements be false, then it will return the false value
IF function in Excel
IF function check if an one operation is True or false, then based on the result its don an operation (if its true) and another operation if it is False
SUBSTITUTE function in Excel
SUBSTITUTE replaces part of a text string, based on the characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use SUBSTITUTE function in different situations.
REPLACE function in Excel
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use REPLACE function in different situations.
T Function in Excel
The Microsoft Excel T function returns the text referred to by a value. The T function is a built-in function in Excel that is categorized as a String/TextFunction. It can be used as a worksheet function in Excel
In this video we described how to use T function in different situations
EXACT Function in Excel
The EXACT function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document. In this video we described how to use EXACT function in different situations.
TEXTJOIN function in Excel
The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells, and has a setting to ignore empty values.
In this video we described how to use TEXTJOIN function in different situations.
REPT Function in Excel
The Microsoft Excel REPT function returns a repeated text value a specified number of times. This function is categorized as a String/Text Function.
In this video we described how to use REPT function in different situations.