#1
|
|||
|
|||
Excel Validation Feature to Return Items from a List
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 |
#2
|
|||
|
|||
Can achieve this easily with a VLOOKUP..
See attached. |
Tags |
microsft-excel 2003 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data validation using conditional parameters in Excel table | dougdrex | Excel | 2 | 01-06-2015 07:44 AM |
Data Validation Issue in Excel | rrparekh | Excel | 0 | 10-27-2014 10:53 AM |
Data validation list filter with range defined by OFFSET | Mango123 | Excel | 4 | 03-18-2014 02:52 PM |
Conditional data validation (list drop-down) | click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
Outlook 2007 Saved sent items list only holds the last ten items | david.peake | Outlook | 0 | 06-01-2010 07:27 PM |