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