Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions

Excel Magic Trick 1000 Lookup Last Partial Text Item using SEARCH and LOOKUP functionsПодробнее

Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple RecordsПодробнее

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many DuplicatesПодробнее

Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple RecordsПодробнее

Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail RecordsПодробнее

Excel Magic Trick 309: Partial Text Match: Why 2^15?Подробнее

Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more...Подробнее