Andre wants to include a quick way to determine the level of the membership, which is based on the Amount values. Enter a formula using the HLOOKUP function as follows:

In cell C3, enter a formula using the HLOOKUP function.

Use a structured reference to the Amount column ([Amount]) as the lookup value.

Look up that value in the table array shown in the range G2:J3, using an absolute reference to that range.

Return the value in row 2 of the table array.

Use TRUE as the range_lookup parameter, so that the formula will find the closest approximate value (as the level covers a range of membership amounts.)

Fill the formula into the range C4:C55, if necessary.

Clear the contents of cell C56 in the Total row.