Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill text
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto fill text
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 On Mon, 2 Apr 2007 08:12:02 -0700, cac1966 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quick ? on how to auto fill text from one cell to another | Excel Discussion (Misc queries) | |||
using auto fill edit or fill handel | Excel Worksheet Functions | |||
Auto fill | Excel Discussion (Misc queries) | |||
How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions |