Creating a schedule
 

Trying to set up an appointment schedule in Excel linking it to a stting of
info on each person. Original data is in access and also have a generated
list in Excel.
I want to be able to type in someone's unique number and display several
cells of data (first name, last name, date of birth, telephone, etc.)

Creating a schedule
 

Beth
Look up VLookup in Help. HTH Otto
"Beth DL" <Beth wrote in message
...
Trying to set up an appointment schedule in Excel linking it to a stting
of
info on each person. Original data is in access and also have a generated
list in Excel.
I want to be able to type in someone's unique number and display several
cells of data (first name, last name, date of birth, telephone, etc.)

Creating a schedule
 

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for inputting
the data if need be.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 11:36:01 -0700, Beth DL <Beth
wrote:

Trying to set up an appointment schedule in Excel linking it to a stting of
info on each person. Original data is in access and also have a generated
list in Excel.
I want to be able to type in someone's unique number and display several
cells of data (first name, last name, date of birth, telephone, etc.)