For specified Unit # in cell B2 on image provided, what should be an correct for INDEX - MATCH lookup function that provide Rental Price in cell E2?Assume that the data range start from row 7 to row 56. Group of answer choices=INDEX(A7:H56,MATCH(B2,A7:A56,0),4)=MATCH(A7:H56,INDEX(B2,A7:A56,0),4)=INDEX(A7:H56,MATCH(B2,A7:H56,0),1)=INDEX(A7:H56,MATCH(B2,A7:H56,1),1)

The correct formula for the INDEX - MATCH lookup function that provides the Rental Price in cell E2 for a specified Unit # in cell B2 is:

=INDEX(A7:H56,MATCH(B2,A7:A56,0),4)

This formula works by using the MATCH function to find the row number of the value in cell B2 within the range A7:A56. The INDEX function then uses this row number, along with the column number 4 (which corresponds to the Rental Price), to return the corresponding value from the range A7:H56.