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.