Remember Me?

#1
January 31st 07, 04:14 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 7
Referencing Numbers

I have a large (master) spreadsheet I made showing NBA players and using
standard deviation I have been able to give the players rankings in different
categories. I also have separate spreadsheets for each team listing their
players, and each players ranking in each category. That sheet sums up each
teams category and sends those numbers to another sheet that compares each
team.

What I usually have to do is copy each players rankings one at a time and
paste them onto the corresponding sheet. What I'm wondering is.....is it
possible to link the sheets so that when i put a players name on one of the
teams sheet, it will look up that name on the master sheet and list the
rankings in separate cells? I was thinking I could somehow use the if
statement to do something like this:

if(a4=bryant kobe, b4, if(a5=bryant kobe, b5.........)

The problem is there are 270 lines and I don't think I can do an if statment
that long.

I know there is a lookup term I can use, but can I use that to have it move
the numbers automatically from the master sheet to the separate sheets?

#2
January 31st 07, 06:43 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 6,582
Referencing Numbers

Put the player's name in the first column of your master sheet of all
players. Then use VLookup (not If) to populate the other sheets based on the
player's name entered in its first column.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"pugsly8422" wrote in message
...
I have a large (master) spreadsheet I made showing NBA players and using
standard deviation I have been able to give the players rankings in
different
categories. I also have separate spreadsheets for each team listing their
players, and each players ranking in each category. That sheet sums up
each
teams category and sends those numbers to another sheet that compares each
team.

What I usually have to do is copy each players rankings one at a time and
paste them onto the corresponding sheet. What I'm wondering is.....is it
possible to link the sheets so that when i put a players name on one of
the
teams sheet, it will look up that name on the master sheet and list the
rankings in separate cells? I was thinking I could somehow use the if
statement to do something like this:

if(a4=bryant kobe, b4, if(a5=bryant kobe, b5.........)

The problem is there are 270 lines and I don't think I can do an if
statment
that long.

I know there is a lookup term I can use, but can I use that to have it
move
the numbers automatically from the master sheet to the separate sheets?

#3
January 31st 07, 07:22 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 7
Referencing Numbers

This worked great....thanks a lot for your help.

"Jon Peltier" wrote:

Put the player's name in the first column of your master sheet of all
players. Then use VLookup (not If) to populate the other sheets based on the
player's name entered in its first column.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"pugsly8422" wrote in message
...
I have a large (master) spreadsheet I made showing NBA players and using
standard deviation I have been able to give the players rankings in
different
categories. I also have separate spreadsheets for each team listing their
players, and each players ranking in each category. That sheet sums up
each
teams category and sends those numbers to another sheet that compares each
team.

What I usually have to do is copy each players rankings one at a time and
paste them onto the corresponding sheet. What I'm wondering is.....is it
possible to link the sheets so that when i put a players name on one of
the
teams sheet, it will look up that name on the master sheet and list the
rankings in separate cells? I was thinking I could somehow use the if
statement to do something like this:

if(a4=bryant kobe, b4, if(a5=bryant kobe, b5.........)

The problem is there are 270 lines and I don't think I can do an if
statment
that long.

I know there is a lookup term I can use, but can I use that to have it
move
the numbers automatically from the master sheet to the separate sheets?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jeffery Keown Excel Discussion (Misc queries) 5 October 17th 06 03:45 PM Lofty Excel Worksheet Functions 7 July 10th 06 09:06 PM William Excel Worksheet Functions 1 June 6th 06 05:30 AM KBear Excel Discussion (Misc queries) 2 April 21st 06 01:40 PM crafty_girl Excel Worksheet Functions 2 April 18th 06 07:29 PM

All times are GMT +1. The time now is 08:37 AM.