VLookup Formula

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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1

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

--

Originally Posted by 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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1