Question: 1 9 . The Companies table in the range E 3 :I 9 lists information about the Amari's current insurance company ( Highland ) and
The Companies table in the range E:I 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 E:F for looking up data in the Companies table. Look up the score assigned to the Highland insurance company:
a In cell E begin to enter a formula using the XLOOKUP function.
b Use the value in cell E 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 E:I
e Don't return anything if not found, and specify an exact match for the match type.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
