Looking up data from another sheet

[Kat]

Hi, I'm very confused!
I'm used to using Access databases and often create tables and queries for a
combo box in a field so I can select the appropraite data.

I know this is possible in Excel to an extent too and would love to know how
to do it. I've been trying all morning and getting nowhere.

For example in Sheet One I will have the headings Issue Title, Opened By,
Date Opened, Due Date, Prioirty, Status and Description

In Sheet Two I would like lists of options to put in Opened By, Priority and
Status

Please help!

[Harald Staff]

See Debra's pages on Data validation:
http://www.contextures.com/xlDataVal01.html

HTH. Best wishes Harald


"Kat" <[email protected]> skrev i melding
news:[email protected]...
> Hi, I'm very confused!
> I'm used to using Access databases and often create tables and queries for
a
> combo box in a field so I can select the appropraite data.
>
> I know this is possible in Excel to an extent too and would love to know
how
> to do it. I've been trying all morning and getting nowhere.
>
> For example in Sheet One I will have the headings Issue Title, Opened By,
> Date Opened, Due Date, Prioirty, Status and Description
>
> In Sheet Two I would like lists of options to put in Opened By, Priority
and
> Status
>
> Please help!