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?

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?

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?

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?