Excel Validation Feature to Return Items from a List

[summerabc]

I have a list of bank code and bank description in spreadsheet. i wanted to select a bank code from a list and then display the bank's description. How can i perform this ? Sorry im new with excel validation. Any help would be appreciated.

Worksheet 1
--------------
(current issue: when the bank code is selected from the list, it will display only bank code )


WorkSheet 2
-----------------



Question : how to display the bank description when i select the bank code?
My excel File : Book1.xls


what i've done so far.
1) Insert -> name -> define -> =Sheet2!$A$2:$A$10 (BANK)


2) Data -> validation -> settings -> list -> source: -> =BANK