Hellow guys, Welcome to my website, and you are watching Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples). and this vIdeo is uploaded by excelisfun at 2011-02-05T12:17:49-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples) |
| Video Uploader | Video From excelisfun |
| Upload Date | This Video Uploaded At 05-02-2011 20:17:49 |
| Video Discription | Excel Start File: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010IsFun!START.xlsm Excel Finished File: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010IsFun!FINISHED.xlsm Free Excel 2010 book: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010IsFun!.pdf 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 |
| Category | Education |
| Tags | Office | 2010 | Mike | Gel | Girvin | excelisfun | Highline | Community | College | Busn | 216 | Computer | Applications | Class | Excel | VLOOKUP | function | formula | with | Approximate | Match | Exact | looking | up | product | price | tax | rate | assign | sales | category | to | number |
