Excel: Question

[_Pete_]

Hi.

I am using Excel 2007 in a vista premium home esition. I have 3 worksheets,
Sales Order, Companys, Product.
On the sales order, I have a box I want to call company ID #, I want to
select the company and I want it to populate the Companies address, I have
the following Addess, City, County, State, Zip.

I would like a window to show me company ID and Name, and when I click on it
I want to put the ID number in the cell and like I mentioned the address
filled out.

Now I would like to know where I can find more info on this so I can read
about it and do it or else just some basic info so I can attempt to do it
myself.

Thanks,

Peter

 

[Ed Ferrero]

Hi Peter,

Sounds like you want to use the VLOOKUP function... - Do I sound like clippy


Have a look at my Excel Database tutorial for some tips on how to set this
out
http://www.edferrero.com/ExcelTutorials/ExcelDatabaseTutorialPart1/tabid/90/Default.aspx

Ed Ferrero
www.edferrero.com