Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2015, 10:55 PM
summerabc summerabc is offline Excel Validation Feature to Return Items from a List Windows 7 64bit Excel Validation Feature to Return Items from a List Office 2003
Novice
Excel Validation Feature to Return Items from a List
 
Join Date: Jan 2015
Posts: 1
summerabc is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-16-2015, 04:37 AM
thetraininglady thetraininglady is offline Excel Validation Feature to Return Items from a List Windows 7 64bit Excel Validation Feature to Return Items from a List Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Can achieve this easily with a VLOOKUP..
See attached.
Attached Files
File Type: xls Book2.xls (33.0 KB, 6 views)
Reply With Quote
Reply

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
Excel Validation Feature to Return Items from a List Data validation list filter with range defined by OFFSET Mango123 Excel 4 03-18-2014 02:52 PM
Excel Validation Feature to Return Items from a List 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft