Highline Excel Class 07: VLOOKUP function formula 7 Examples

Download Excel Start File 1: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Week2Busn214.xls Download Excel Start File 2: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Week2Busn214Workbook2.xls Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Week2Busn214Finished.xls Learn about: 1)VLOOKUP to lookup an exact match 2)VLOOKUP to lookup an approximate match 3)VLOOKUP can return a value to a cell 4)VLOOKUP can return a value to a formula 5)VLOOKUP can lookup values on a different sheet (Name table and use name in VLOOKUP function) 6)Use VLOOKUP to return values from column 2 of the lookup table 7)Use VLOOKUP to return values from column 3 of the lookup table 8)Use VLOOKUP and COLUMNS function together for lookup tables with more than 2 columns This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109