Question: 1 . Michael has created an area in the range J 1 :L 4 for looking up data in the Office table. First, he wants
Michael has created an area in the range J:L for looking up data in the Office table. First, he wants to find the purchase price for a specific item. He has already entered the item ID in cell J Look up the price of the item with Item ID as follows:
a In cell J begin to enter a formula using the VLOOKUP function.
b Use the Item ID in cell J as the value to look up
c Use a structured reference to the Office table as the table to search.
d Display the value in the Purchase Price column column of the table.
e Specify an exact match FALSE for the rangelookup argument.
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
