Drop Down List from one worksheet to another

[Angel V.]

I have data on a worksheet, alphabetized by a certain column. On another
worksheet, I would like to be able to create a drop down list to choose one
of these values. then have that value, plus other values show up on the
worksheet.

Can this be done?

 

[Mike Rogers]

Angel

If I understand you correctly yes you can. You would do it via "Data
Validation" under the "Data" menu. Use this link to learn more than you will
need: http://www.contextures.on.ca/tiptech.html Look for "Data Valadation
and it sounds like you may want to read up on "Dependant Lists".

Mike Rogers

 

[Don]

Sounds like a combination of Data / Validation and Vlookup's? First , go to
the sheet with the values you want in the dropdown and select the range (like
A1:A25) , then in the uppper left corner that probly says A1, type over it
with the name you want like "LIST1". (I usualy highlight this so I know my
range) Then on the other sheet you want the dropdown in the cell, select the
range and do Data / validation and then do allow "List" and do "=LIST1".
Step one done.

Then in the next cell you can do a vlookup on what was selected from the
drop down to other values

 

[Angel V.]

I've done what you said, but the value I get in the vlookup box is the same
all the way down, even tho I've changed the drop down selection. I'm sure
it's in my validation setup, but can't figure out what.

 

[Gord Dibben]

May be nothing wrong with your DV setup.

Could be that calculation is set to manual under Tools>Options>Calculation.

BTW........when you say "lookup box" do you mean a cell with a vlookup formula
entered?


Gord Dibben MS Excel MVP

 

[Angel V.]

Nothing wrong with my DV setup. Found that Lookup formula worked better in
this situation, but wouldn't have gotten there without the previous help!
So...many thanks!!

2nd question: yes, vlookup box means the box I had the formula in.

Now...I've got another thing going on.

Same data, added another table to pull from: across the top are column
labels A,B,C etc. Down the left hand side are A01, A02 etc. with data in
various cells, but not all cells (much like a mileage finder in an atlas).
How can I find the first column that has data??

I'll try to explain better, but please be patient

A B C D
A01 44 72 204
A02 35 91 105
A03 52 77


I would like to look for A03 returning the result "C" column. (with the
first data for A03 being in column C)

Thanks for any help!