Drag and Drop Down list!?

N

Neo1

Hello I want to create a drag and drop down list but how can I create
one by getting the list of data from another worksheet in the same
file?


Thanks
From John
 
L

L. Howard Kittle

Hi John,

You can name the list on the other sheet and then in the Source box enter
=NameOfList.

HTH
Regards,
Howard
 
N

Neo1

Thanks, but now the problem lies in doing the IF statement, such that
when i try to say IF the cell with the drag and drop list is "this name
(stated in other worksheet" then put 5 etc...Do i need to type in the
whole name? What i did is just clicked on a cell of data list of the
other worksheet so that for example

=IF(B6 = Sheet2!C6,"5"........ This way it doesnt seem to work i
need to type in the full name instead of putting the cell number.....
isnt there another way instead of putting the entire name?

Thanks
From John
 
L

L. Howard Kittle

Hi John,

On the sheet that has the list, go there and name the list. I will call it
"MyList".
Back on the sheet with the drop down, under Data > Valadation > Sittings >
Allow > List In > Source > =MyList > OK.

Should get you there.

No IF statement needed.

HTH
Regards,
Howard
 
Top