VLOOKUP question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
Identify Duplicates that are not identical 4
Combining multiple rows with duplicate info -- help! 1
Show only rows with duplicate values in a column? 4
microsoft access combobox auto-filled fields cannot be seen on report 0
Is there a way to separate FirstName and LastName ? 4
Access Creating names from fields in access database. 0
Pesky spaces 1

Back
Top