Look Up the 2nd, 3rd or Nth Match in Excel
VLOOKUP only finds the first match. Return a customer’s Nth order, the first N rows, the last match or the Nth largest per group with FILTER+INDEX, SMALL+IF, AGGREGATE and a helper-column method.
Read article →