Dueling Excel 116


Extract Individual Letters From Cell and do Lookup Adding, then…

DESCRIPTION

See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then show one of three categories: ‘Under Zero”, “Zero” or “Over Zero”.
Concepts:
1. Take Text Strings from cells
2. Extract all letters
3. Lookup each letter to get value equivalent from lookup table
4. Add the lookup values
5. Assign the text “Under Zero”, “Zero”, “Over Zero”
6. VBA User Defined Function
7. Custom Number Formatting
8. Array Formulas with the functions: INDIRECT, ROW, MID, LOOKUP, SUMPRODUCT, SIGN, and CHOOSE

WORKBOOKS