database autofill
 

I have a data base where i have to enter numerous fields. For example, i
enter an id number, then the persons name and address. I have a database
that has every id number and name and address. Basically i want to enter an
id number and reference it back to the database so the name and address
automatically show up after i enter the id number?

database autofill
 

The best solution will be VLOOKUP and if you combine it with DATA
VALIDATION(dropdown list) you will have a powerfull tool.
Post back for direction, now I have to go, but I'll be back soon.
--
Can''''t hear the Rain ?
Then listen to it.


"kable58" wrote:

I have a data base where i have to enter numerous fields. For example, i
enter an id number, then the persons name and address. I have a database
that has every id number and name and address. Basically i want to enter an
id number and reference it back to the database so the name and address
automatically show up after i enter the id number?

database autofill
 

Ok, i am unfamiliar with Vlookup but will research it. Basically here is
what I have. A huge database with four columns. Column a is ID #, B Last
name, C first name and D address. When somebody places an order through my
company, i verify they are on the master list, but then record them onto
another spreadsheet. For time saving purposes, i would ideally be able to
just type in their ID# and have columns b c and d automatically pop up.

"The Rain" wrote:

The best solution will be VLOOKUP and if you combine it with DATA
VALIDATION(dropdown list) you will have a powerfull tool.
Post back for direction, now I have to go, but I'll be back soon.
--
Can''''t hear the Rain ?
Then listen to it.


"kable58" wrote:

I have a data base where i have to enter numerous fields. For example, i
enter an id number, then the persons name and address. I have a database
that has every id number and name and address. Basically i want to enter an
id number and reference it back to the database so the name and address
automatically show up after i enter the id number?

database autofill
 

VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

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

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

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 08:43:00 -0800, kable58
wrote:

Ok, i am unfamiliar with Vlookup but will research it. Basically here is
what I have. A huge database with four columns. Column a is ID #, B Last
name, C first name and D address. When somebody places an order through my
company, i verify they are on the master list, but then record them onto
another spreadsheet. For time saving purposes, i would ideally be able to
just type in their ID# and have columns b c and d automatically pop up.

"The Rain" wrote:

The best solution will be VLOOKUP and if you combine it with DATA
VALIDATION(dropdown list) you will have a powerfull tool.
Post back for direction, now I have to go, but I'll be back soon.
--
Can''''t hear the Rain ?
Then listen to it.


"kable58" wrote:

I have a data base where i have to enter numerous fields. For example, i
enter an id number, then the persons name and address. I have a database
that has every id number and name and address. Basically i want to enter an
id number and reference it back to the database so the name and address
automatically show up after i enter the id number?