DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions [Read More >>>]
DESCRIPTION See how to create a formula to perform Case Sensitive Lookup: (00:10) Introduction (00:16) VLOOKUP by itself will NOT work. (01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case [Read More >>>]
DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]
Be the first to comment
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.