Newbie Cell Reference Question...

[UncleRemus]

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

[paul]

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
>
>

[Roger Govier]

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
>
>