Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT915.xlsx Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm If you have a hard time understanding what VLOOKUP does, this video is for you! Topics covered: 1. How to understand what arguments the VLOOKUP needs and how the VLOOKUP Function works. 2. Banking Example where we need to lookup an average bank balance and retrieve the month maintenance charge and the per-heck charge. 3. Looking up sales made and return a commission rate (Approximate match) 4. Lookup Income and return tax rate (Approximate match) 5. Lookup Square feet of land and return the correct drainage pipe size (Approximate match) 6. Lookup Student points earned in a class and return the decimal grade (Approximate match) 7. Lookup Student points earned in a class and return the letter grade (Approximate match) 8. Lookup Sales Representative name and return a contractual commission rate (Exact match) 9. Sort first column and then Lookup Sales Representative name and return a contractual commission rate (Approximate match)