Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

auto fill text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cac1966 - 02 Apr 2007 16:12 GMT
I want to be able to have excell look for a company's name and autfill it on
the Purchase order.  I have typed the companies names and addresses on the
bottom of the worksheet.  I have the Purchase Order at the top of the
worksheet.  I lined up the company name and the blank on the same row "C" but
when I type the first few letters it doesnt auto fill for me.  So I want to
try to do something different so that I dont have to type the complete
company name and address each time.
Gord Dibben - 02 Apr 2007 20:29 GMT
This is generally done through a VLOOKUP formula.

You have a lookup table in two columns.

Column one with a unique identifier and column two with the company name.

Type in the identifier number and the company name appears in the cell with the
formula.

For more on this see Debra Dalglesih's site on VLOOKUP.

http://www.contextures.on.ca/xlFunctions02.html

And perhaps a DV DropDown list to choose the identifier.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben  MS Excel MVP

>I want to be able to have excell look for a company's name and autfill it on
>the Purchase order.  I have typed the companies names and addresses on the
[quoted text clipped - 3 lines]
>try to do something different so that I dont have to type the complete
>company name and address each time.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.