linking data and text cells

spoogehead

New Member
Joined
Sep 15, 2002
Messages
31
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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
ABCD
1Source
2NameValue
3Jones5
4Smith10
5
6DataResult
7Jones5
8Jones5
9Jones5
10Jones5
11Smith10
12Smith10
13Smith10
14Smith10
15
Sheet3


Post back if you need more,

Paddy
 
Upvote 0

Forum statistics

Threads
1,217,383
Messages
6,136,272
Members
450,001
Latest member
KWeekley08

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top