Using a drop down list

[SrA Flyboy21]

I am trying to set up an invoice so that when I use a drop down list for the
customer name, it will automatically enter the address in the column oposite
the customer name. any help would be great!

 

[Ashish Mathur]

Hi,

Please see data> validation> Lists

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html