Hello,
I apologize if this question has been answered before, but I'm not
quite sure what to search for as I'm not very good with excel.

I'm making a spreadsheet where one sheet references another. I'll try
to explain this as best as possible....

I'm creating a spreadsheet for a fantasy basketball league. I have a
"Data" sheet that contains data for all players. I have another sheet,
"Teams" that has all the players on each team. Column B contains the
players name, and column C contains a number that corresponds to the
row this player is on in the data sheet. So, for instance, if the
player is Dwayne Wade, the C cell contains the data "32", which is the
row this player is on in the data sheet. Now, to display his FG%, I
could put in the formula "=DATA!R32", but I want to put
"=DATA!R(TEAMS!C4)". Cell C4 being "32". I realize putting this C4
cell into parentheses isn't the way to do it, but that is my question.
How would I do this?

I hate to hard code it, as it would take ages and be messy, but I have
no idea how to do it otherwise. I hope I worded this in such a way
that someone can understand it and help me out.

Any help would be appreciated very much...


Thanks,
Ross


--
UncleRemus
------------------------------------------------------------------------
UncleRemus's Profile: http://www.excelforum.com/member.php...o&userid=28429
View this thread: http://www.excelforum.com/showthread...hreadid=480241

i would think a vlookup would accomplish what you want without your special
column for which row they are in the table,I dont know how you have your
players displayed or listed but in the second column of your teams page you
could have =vlookup(playername on data sheet table, absolute data table range
reference,column number for data reqired,false),copy across and down as
required ......
--
paul
remove nospam for email addy!



"UncleRemus" wrote:


Hello,
I apologize if this question has been answered before, but I'm not
quite sure what to search for as I'm not very good with excel.

I'm making a spreadsheet where one sheet references another. I'll try
to explain this as best as possible....

I'm creating a spreadsheet for a fantasy basketball league. I have a
"Data" sheet that contains data for all players. I have another sheet,
"Teams" that has all the players on each team. Column B contains the
players name, and column C contains a number that corresponds to the
row this player is on in the data sheet. So, for instance, if the
player is Dwayne Wade, the C cell contains the data "32", which is the
row this player is on in the data sheet. Now, to display his FG%, I
could put in the formula "=DATA!R32", but I want to put
"=DATA!R(TEAMS!C4)". Cell C4 being "32". I realize putting this C4
cell into parentheses isn't the way to do it, but that is my question.
How would I do this?

I hate to hard code it, as it would take ages and be messy, but I have
no idea how to do it otherwise. I hope I worded this in such a way
that someone can understand it and help me out.

Any help would be appreciated very much...


Thanks,
Ross


--
UncleRemus
------------------------------------------------------------------------
UncleRemus's Profile: http://www.excelforum.com/member.php...o&userid=28429
View this thread: http://www.excelforum.com/showthread...hreadid=480241

Hi

You could use Indirect()
=INDIRECT("DATA!R"&TEAMS!C4)

Regards

Roger Govier


UncleRemus wrote:
Hello,
I apologize if this question has been answered before, but I'm not
quite sure what to search for as I'm not very good with excel.

I'm making a spreadsheet where one sheet references another. I'll try
to explain this as best as possible....

I'm creating a spreadsheet for a fantasy basketball league. I have a
"Data" sheet that contains data for all players. I have another sheet,
"Teams" that has all the players on each team. Column B contains the
players name, and column C contains a number that corresponds to the
row this player is on in the data sheet. So, for instance, if the
player is Dwayne Wade, the C cell contains the data "32", which is the
row this player is on in the data sheet. Now, to display his FG%, I
could put in the formula "=DATA!R32", but I want to put
"=DATA!R(TEAMS!C4)". Cell C4 being "32". I realize putting this C4
cell into parentheses isn't the way to do it, but that is my question.
How would I do this?

I hate to hard code it, as it would take ages and be messy, but I have
no idea how to do it otherwise. I hope I worded this in such a way
that someone can understand it and help me out.

Any help would be appreciated very much...


Thanks,
Ross