Looking up data from another sheet

G

Guest

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!
 

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

Top