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 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.

Answer 1

Here we need to understand Vlookup function.

Based on the information provided in question a sample excel worksheet is prepared as under

With formula

Sample FallMemberships table as the table array is made in cells from A1 to B6

To get membership type for Membership no. entered in cell H2 i.e. 14560 from the sample table array made in cells from A1 to B6 formula is used in cell H3

Formula explanation

=VLOOKUP(H2,$A$1:$B$6,2,0)

H2 refers to cell whose membership type we want as a result

$A$1:$B$6 refers to table array. Table array is to be freezed to get the correct value.

2 is used to indicate that in table array we want values of second column i.e. B Column

0 is used as we want value with exact match. We want membership type of exact membership no. 14560 only and not approx to membership no. 14560