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

1. Michael has created an area in the range J1:L4 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 J2. Look up the price of the item with Item ID 332 as follows:
a. In cell J4, begin to enter a formula using the VLOOKUP function.
b. Use the Item ID in cell J2 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 6) of the table.
e. Specify an exact match (FALSE) for the range_lookup argument.

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 Programming Questions!