linking a cell containing text to another cell containing text / data

Giganews Newsgroups
Subject: linking a cell containing text to another cell containing text / data
Posted by:  gin2000 (gin2000.282brb_1148055601.5488@excelforum-nospam.com)
Date: Fri, 19 May 2006

Hi, I am looking for a formula to link a cell containing text to another
cell containing text / data.

Example: I have a list of 'countries' in Cell A1 (using data validation
- lists). In cell B1 I want to have the 'number of states per country'
automatically populate (corresponding to the country selected in cell
A1). Naturally, I will have to have a separate table somewhere on the
page that links the 2 fields.

My question is 'how do i go about linking the 2 fields?

Any help is much appreciated.
Gin

--
gin2000
------------------------------------------------------------------------
gin2000's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34606
View this thread:http://www.excelforum.com/showthread.php?threadid=543774

Replies