Help!!!

  • Thread starter Thread starter awdl22125
  • Start date Start date
A

awdl22125

Can you tell me how to drop information onto a standard form in one
worksheet from a database on another worksheet. For example by picking
a persons name from a drop down menu, their personal information (pay
number, address etc) would drop into the standard letter.
:confused:
 
VLOOKUP Function will do this for you.

Assume your Database sheet is laid out as....

Column A Name
Column B Pay Number
Column C Address
Column D Date of hire(or whatever)

You may have more columns, adjust to suit.

On form sheet in a cell of your choice place your drop-down list of names
using Data>Validation with the names as your list.

At points where you want the appended information to be placed enter VLOOKUP
formulas.

Assuming your 4 columns of data have titles and extend 40 rows down.

you want pay number in B4 enter =VLOOKUP(DVcell,Database!A2:D40,2,FALSE)

you want address in F5 enter =VLOOKUP(DVcell,Database!A2,A2:D40,3,FALSE)

DVcell is the "cell of your choice".

You can give a range name to the Database!A2:D40 using Insert>Name>Define and
use that in your formulas.

That's the basics.

Gord Dibben XL2002
 
Back
Top