VLOOKUP question

D

Diane

I have a form where I would like to type the name of a person and relevant
info automatically fills in the other columns.

I have set up a separate spreadsheet with columns A-E with data as follows:
Spreadsheet columns are:
LastName FirstName Title Tel# Email

Form columns are:
Name Title Tel# Email

What formula do I need to put on my form to connect the "Name" field of my
form to the "LastName and FirstName" together (from spreadsheet) that will
populate the other columns on my form?
 
B

Biff

Hi!

You'd be much better off using just a single column (cell) for the name in
your database then a simple Vlookup would do just fine. Otherwise, it's much
more complicated and depends on how you enter the name in your form.

Biff
 
Top