P
potsie via OfficeKB.com
I really don't have the knowlege to set up this function, I need help on the
line to enter information also.
The problem I have reads as follows: Create an appropriate lookup table for
the membership information. The membership information is contained in cells
A16 through C20. For example, the cost of an individual membership is $290, a
family is $1250 and the deluxe membership is $500. Hint given: The
information given in cell A16 through C20 is not in correct format for
Vlookup function to work. On the worksheet all the customers various
memberships are listed in Column B, on the bottom of the worksheet it is
broken down into three categories A18 is individual, A19 is family, A20 is
deluxe. Next to this column is costs B18 is $290 for individual, B19 is
$1250 for family, and B20 is $500 for deluxe. I need help on the lines to put
these on that is how bad this is for me. Please help
line to enter information also.
The problem I have reads as follows: Create an appropriate lookup table for
the membership information. The membership information is contained in cells
A16 through C20. For example, the cost of an individual membership is $290, a
family is $1250 and the deluxe membership is $500. Hint given: The
information given in cell A16 through C20 is not in correct format for
Vlookup function to work. On the worksheet all the customers various
memberships are listed in Column B, on the bottom of the worksheet it is
broken down into three categories A18 is individual, A19 is family, A20 is
deluxe. Next to this column is costs B18 is $290 for individual, B19 is
$1250 for family, and B20 is $500 for deluxe. I need help on the lines to put
these on that is how bad this is for me. Please help