Main Profile

At A Glance

Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Type "man" and return all e-mails and phone numbers with last names that start with "man" 2. See the functions SEARCH, INDEX, ROW, ROWS, IF and ISNUMBER and SMALL in an array formula 3. Related videos: Excel 2010 Magic Trick 798: Excel Partial Text Lookup Formula To Return Multiple E-mail Records Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records
Length: 07:30

Contact

Questions about Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records

Want more info about Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question