Dependent cell values - help please

[Mike]

Hello,

I'm looking for some step-by-step help on how I can create dependent cells
in the invoice template that I am using.

My idea is to have an account number assigned to each customer, whereby
selecting the appropriate account number inserts the customers address in the
cells, c8:c12 - or vice versa, selecting the appropriate customer, changes
the cell, f17, to the correct account number.

Hope it makes sense and that someone can help an inexperienced Excel user?!

Thanks in advance.

 

[Beth Melton]

Look into the VLOOKUP and/or HLOOKUP functions.

What it sounds like you really need is an Access database.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/