Mike ‘ExcelisFun’ Girvin has produced Tutorials each day this week for the VLOOKUP WEEK 2012 effort. In this post, Two (2) Videos Tutorials from Mike!
VLOOKUP WEEK 2012 Tutorial #5: “CHOOSE Function – Beginner to Advanced with 12 Examples”
“Unlike other lookup functions, CHOOSE lets you lookup “things” besides values: Text, Numbers, Formulas, Functions, Cell References, Ranges, Defined Names, Array Constants” You may Download the workbook at: http://people.highline.edu/mgirvin/ExcelIsFun.htm
VLOOKUP WEEK 2012 Tutorial #6: “Excel Lookup Picture Approximate or Exact match”
See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or Exact match lookup.
See formula inserted into picture for Excel 2010 and 2003.
See formula inserted into bitmap image for Excel 2007.
You may Download the workbook at: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Find more of Mike Girvin’s Excel Tutorials at ExcelisFun On YouTube.