Microsoft Office Forums


Reply
Thread Tools Display Modes

Excel: Question

 
 
_Pete_
Guest
Posts: n/a

 
      05-29-2008, 08:02 AM
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

 
Reply With Quote
 
 
 
 
Ed Ferrero
Guest
Posts: n/a

 
      05-29-2008, 08:15 AM
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/ExcelTutori...0/Default.aspx

Ed Ferrero
www.edferrero.com

 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Question alish Excel Newsgroup 3 04-10-2008 04:50 PM
excel question Administrator Excel Newsgroup 2 05-13-2006 01:39 PM
Re: excel vba question Sandy Mann Excel Newsgroup 4 03-21-2006 08:26 PM
Excel vba question levy.pate@baesystems.com Excel Newsgroup 3 12-02-2005 12:40 PM
excel vba question levy.pate@baesystems.com Access Newsgroup 1 12-01-2005 04:33 PM



All times are GMT. The time now is 02:20 PM.