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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,139
Messages
5,599,951
Members
414,350
Latest member
ajesh27

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
Top