software

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
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:
gt; I am to create a lookup table for membership information. The
gt; membership
gt; information is contained in cells A16 through C20 this tells the type
gt; of
gt; membership ex: individual, family or deluxe. Column B18 to B20 gives
gt; the cost
gt; of the membership. There is a note that the information given in A16 to
gt; C20
gt; is not in correct format for a vlookup function to work. Help!
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...excel/200604/1--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=535380