Question: 19. Switch to the Fall worksheet. In the Fall worksheet, Andre wants to include a quick way to look up member information based on the
19. Switch to the Fall worksheet. In the Fall worksheet, Andre wants to include a quick way to look up member information based on the Member ID value. To display the type of membership, enter a formula in cell H3 using the VLOOKUP function as follows:
a. Use cell H2 as the lookup value.
b. Use a reference to the FallMemberships table as the table array.
c. Use column 2 as the column index number.
d. Use FALSE as the range_lookup argument, so that the function returns an exact match to the Member ID value shown in cell H2.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
