Main Profile

At A Glance

Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup

Learn about some common confusion between lookup and data extraction. See the LEFT and TRIM functions and adding zero to convert text to a number create the criteria for lookup, and see how sorting and copy and paste will help to avoid large array formulas.
Length: 05:16

Contact

Questions about Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup

Want more info about Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question