How do you use the INDEX-MATCH combination in Excel?
a. You use =AVERAGE(range)
b. You use =INDEX(return_range, MATCH(lookup_value, lookup_range, 0) )
c. You use =CONCATENATE(text1, text2)
d. You use =SUM(range)