See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"SrA Flyboy21" wrote in message
...
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!