Downloads:
Busn214SIBWMOE2007Chapter05romMGirvin.xlsm
Busn214SIBWMOE2007Chapter05romMGirvinSolution.xlsm
Chapter05TextExamplesand HWsolutions.xls

Data Validation & VLOOKUP Handout

Class Content YouTube videos:
Excel Lookup Series #1: VLOOKUP Function 1st Example
Excel Lookup Series #2: VLOOKUP Function 2nd Example
Excel Lookup Series #3: VLOOKUP Function 3rd Example
Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example
Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example
Excel Lookup Series #6: HLOOKUP Function
Excel Lookup Series #7: LOOKUP Function
Excel Lookup Series #8: MATCH Function
Excel Lookup Series #9: INDEX function 1st Example
Excel Lookup Series #10: INDEX function 2nd Example
Excel Lookup Series #11: INDEX & MATCH functions Example 1!
Excel Lookup Series #12: INDEX & MATCH functions Example 2!
 

Extra Related You Tube videos:
Names, Data Validation, VLOOKUP
INDEX and MATCH instead of VLOOKUP
IFERROR and VLOOKUP functions