Question

Analyze the table below. It is a comparative study of how the weights of infants increase as they grow up. What LOOKUP function will you use to find out the weight of Infant 3 during month 2?

Answer 1

You’d use weight and make sure you divide the weight by the length of the child

Answer 2

(Answers may vary, but your answer should include the following points.)

I used the Matrix LOOKUP function because I needed to find a value that’s at the intersection of a column and a row.

Next, I identified each parameter in the formula.

Finally, I put the values in the formula and computed the result as below:

INDEX (A2:E6, MATCH (A5, A2:A6, FALSE), MATCH (C2, A2:E2, FALSE))

The answer is 11.46.

Step-by-step explanation: