Dueling Excel 116

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


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”.
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


Be the first to comment

Leave a Reply