Multiple Criteria V-Lookups

The spreadsheet, attached, provides a sample of how to perform a V-Lookup using multiple criteria. There are two approaches, index/match and max/index.

 

 

widgets sold