Main Profile

At A Glance

Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more...

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm1. See how to lookup only part of a string, Example lookup and return "FFP" within the larger string "941 FFP393", but formula must return a blank if no match is made.2. See three formulas using the functions LOOKUP, SEARCH, IFERROR, COUNT, IF, CHOOSE, REPT.3. Fuzzy Match4. See cool formula from HOT PEPPER at the Mr Excel Message Board.
Length: 10:48

Contact

Questions about Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more...

Want more info about Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more...? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question