Main Profile

At A Glance

Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. See how to use the VLOOKUP function to look up an item in a table and return something to a cell 2. VLOOKUP with Exact Match (Lookup a word) 3. VLOOKUP with Approximate Match (Lookup a number) 4. Data Validation List (Data Ribbon tab, Data Tools Group, Data Validation) Keyboard = Alt, D, L. 5. VLOOKUP for looking up product price 6. VLOOKUP for looking up tax rate 7. VLOOKUP to assign a sales category to a sales number
Length: 14:54

Contact

Questions about Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)

Want more info about Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question