database autofill

  • Thread starter Thread starter kable58
  • Start date Start date
K

kable58

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.
 
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.
 
Back
Top