Thursday, October 18, 2012

VLOOKUP and complexities

In class with participants. Started thinking about VLOOKUP doing more than what is normally discussed.

Using VLOOKUP to return more than one column in the answer and summing these multiple cells:
http://www.myonlinetraininghub.com/excel-vlookup-multiple-values

Using multiple criteria - don't use VLOOKUP, use INDEX and MATCH nested?
http://spreadsheets.about.com/od/lookupfunction1/ss/2011-03-03-excel-2010-vlookup-multiple-values-sbs-tutorial.htm

VLOOKUP with finer points:
http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=119:vlookup-multiple-values-return-multiple-corresponding-values-for-one-lookup-value&catid=77&Itemid=473

No comments: