linking data and text cells

[spoogehead]

I want to link every occurrance of a name to a corresponding value which is updated every so often. For example:

Jones 2
Bloggs 1

Jones 1
Smith 4

Brown 6
Jones 10

(Apologies, i couldn't get Colo's utility to work). The numbers are in different cells. I want the corresponding numbers for ALL occurrances of Jones to change to whatever value I put in the first "Jones" cell. So if i change the first "Jones" cell to 5, I want all the other "Jones" cells to automatically change to 5. Can this be done. Thanks in advance

 

[PaddyD]

Hi - welcome to the board.

One way would be to use a lookup table that relates your names & their values, then use a formula to return the appropriate value. The function for this is vlookup() - check it out in the help file, and see below for an example:

Book6
	A	B	C	D
1	Source
2	Name	Value
3	Jones	5
4	Smith	10
5
6	Data	Result
7	Jones	5
8	Jones	5
9	Jones	5
10	Jones	5
11	Smith	10
12	Smith	10
13	Smith	10
14	Smith	10
15
Sheet3

Post back if you need more,

Paddy