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:

Using multiple criteria - don't use VLOOKUP, use INDEX and MATCH nested?

VLOOKUP with finer points:

No comments: