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

--

potsie via OfficeKB.com Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535380