Looking up data from another sheet
 

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!

Looking up data from another sheet
 

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

HTH. Best wishes Harald


"Kat" skrev i melding
...
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!