When to use INDEX function? VLOOKUP function only allows you to look up a value based on single criteria. To look up a value based on multiple criteria in separate columns, use this generic formula: {=INDEX(return_range, MATCH(1, (criteria1=range1) * (criteria2=range2) * (…), 0))} Where: Return_range is the range from which…