VLookup Formula

[potsie via OfficeKB.com]

I am to create a lookup table for membership information. The membership
information is contained in cells A16 through C20 this tells the type of
membership ex: individual, family or deluxe. Column B18 to B20 gives the cost
of the membership. There is a note that the information given in A16 to C20
is not in correct format for a vlookup function to work. Help!

 

[Bryan Hessey]

If the first column of your table has a unique identifier then the
VLookup should work, ie, if A16=Individual, A17=Family, A18=Deluxe
etc.

The member record would need their membership type, say in B1, then

=VLookup(B1,A16:C20,2,False)

would return the cost from the second column (B16:B20) for a match in
A

Hope this helps

--