How to Use Multiple Criteria in a VLOOKUP function

Many users think you cannot use multiple criteria in a VLOOKUP Function, but this is wrong.

=VLOOKUP(
     G2&H2,
     CHOOSE(
          {1,2},sales[Name]&sales[Region],sales[Date])
     ,2,FALSE)

DOWNLOAD WORKSHEET