Tech ARP Forums

Go Back   Tech ARP Forums > Software Discussion > General Software
Excel Help! How to link two list? Excel Help! How to link two list?
Register
FAQ Members List Calendar Arcade Mark Forums Read

Google Web www.techarp.com forums.techarp.com

General Software This is the forum for general discussions about software.

Reply
 
LinkBack Thread Tools
Old 11th Jul 2006, 06:34 PM   #1 (permalink)
beat around the bush
 
aKho's Avatar
 
Join Date: 3 Jun 2005
Location: Kuching, Sarawak
Posts: 2,811
Reputation: 1239
aKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud ofaKho has much to be proud of
Rep Power: 19
Default Excel Help! How to link two list?
i'm working on some work data and came across this problem. i'm trying to link two separate list together.

e.g. attached excel file :

when selecting a letter in the drop-down list, a corresponding number should auto-appear on the cell next to it. any gurus can help me with this?

Attached Files
File Type: zip Data Validation.zip (2.0 KB, 4 views)
__________________
aKho is offline   Reply With Quote
SPONSOR

Reply

« Internet Explorer 7 Beta 2 (x86, x64 e IA64) | A useful way to repair XP without reformatting. »

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +8. The time now is 08:10 AM.

Contact Us - Tech ARP - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 1998-2009 Tech ARP. All rights reserved.