Question: 1 9 . The Companies table in the range E 3 :I 9 lists information about the Amari's current insurance company ( Highland ) and

19. The Companies table in the range E3:I9 lists information about the Amari's current insurance company (Highland) and five other companies they are considering, including the score assigned by an independent insurance evaluation agency. Michael has created an area in the range E11:F14 for looking up data in the Companies table. Look up the score assigned to the Highland insurance company:
a. In cell E14, begin to enter a formula using the XLOOKUP function.
b. Use the value in cell E13 as the value to look up.
c. Use a structured reference to the header row of the Companies table as the table to search.
d. Return the value in the range E5:I5.
e. Don't return anything if not found, and specify an exact match (0) for the match type.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!