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.)

Beth
Look up VLookup in Help. HTH Otto
"Beth DL" <Beth (E-Mail Removed)> wrote in message
news:87C06F0D-3C58-4FD0-BA10-(E-Mail Removed)...
> 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.)
>

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 (E-Mail Removed)>
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.)