In your other sheets (and you might like to group them so that you
only need to enter this once), you can put this formula in D1:

=VLOOKUP(C1,Byes!C:D,2,0)

then copy it down as required.

Ungroup the sheets when finished.

Hope this helps.

Pete

On Jan 23, 10:13*pm, T MAT wrote:
I need a formula to link data in a reference sheet, to data in the other
sheets in the workbook.

I have one worksheet that I am using as the reference sheet. *The name of
the sheet is 'Byes'. *In this sheet, I have data in column C that directly
corresponds to the data in column D. *Specifically, column C has text typed
in it and column D will have a number value typed in it. *I need this data in
columns C & D in this sheet, to match with corresponding Data in other
sheets. *Also, if I change the data in column D in my reference sheet, the
data should change in the other sheets in the workbook. *Here's an example. *

In my reference sheet named 'Byes': *C2 = 'Arizona' and D2 = '7'. *In all of
the other sheets in the workbook, if the data in column C = 'Arizona', the
data in column D should = '7'. *Also, in my reference sheet, the data in C3 =
'Denver' and D3 = '8'. *In all of the other sheets, if the data in column C =
'Denver', the data in column D should = '8'. *And so on and so forth. *

Simply put, I have data in my reference sheet named 'Byes'. *Data in column
C has a corresponding value in column D. *In the other sheets in the
workbook, the data in column C should have the corresponding value in column
D according to my reference sheet.

Hopefully I didn't confuse anyone too much. *Thank you in advance for your
help.