we'll learn how to VLOOKUP multiple rows in Excel by applying the VLOOKUP function along with the SUM, INDEX, MATCH, FILTER functions