Insert a vlookup function in cell c5 to display the ring cost for the first student. the cost of the ring type should be an exact match. use appropriate relative and absolute cell references?

Question: Insert a vlookup function in cell c5 to display the ring cost for the first student. the cost of the ring type should be an exact match. use appropriate relative and absolute cell references?

VLOOKUP($B5,$F$2:$G$7,2,FALSE)

Explanation: This VLOOKUP function looks up the ring type of the first student (in cell B5) in the table range from F2 to G7, and returns the corresponding cost from the second column (in cell G2) of the table range. The lookup type is set to exact match (FALSE) so that an exact match for the value being looked up is returned. Relative and absolute cell references are used within the function so that the cell references adjust when the formula is copied. The lookup value (ring type in cell B5) is a relative reference while the table array (F2 to G7) and the column index (2) are absolute references.

Rjwala

Rjwala is your freely Ai Social Learning Platform. here our team solve your academic problems daily.