Vlookup using 2 columns to reference another
Many ways: If one has the new Dynamic array formulas: =FILTER(C:C,(A:A=J1)*(B:B=J2)) If not then: Dealing with Number returns: If your return values are numbers and the match is unique(there is only one John Doe in the data) or you want to sum the returns if there are multiples, then Using SUMIFS is the quickest method. … Read more