Look Who it Was Random video

Mr Excel & excelisfun Trick 116: Extract Individual Letters From Cell and do Lookup Adding, then...

4,426 views · Published 14 March 2013 · 8:29 · Indexed 6 November 2026

Channel: excelisfun · 2013 · Education

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick116.xlsm

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
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

More from this channel