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