LinkedIn Facebook Twitter Gmail 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 LinkedIn Facebook Twitter Gmail Would You Like To Receive Such an Article in Your Email?Join our mailing list to receive our weekly Articles! No Huff! No Fluff! No Spam! … Continue reading How to Use Multiple Criteria in a VLOOKUP function