Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 07, 05:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 7
Default 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?

Thanks in advance!


  #2   Report Post  
Old January 31st 07, 07:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default 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?

Thanks in advance!



  #3   Report Post  
Old January 31st 07, 08:22 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 7
Default 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?

Thanks in advance!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace Old Part Numbers with New Part Numbers in a Macro. Jeffery Keown Excel Discussion (Misc queries) 5 October 17th 06 03:45 PM
conditional formatting Lofty Excel Worksheet Functions 7 July 10th 06 09:06 PM
How to generate sets of random numbers without having duplicates William Excel Worksheet Functions 1 June 6th 06 05:30 AM
Why are 1/2 my numbers imported as text and the rest as numbers? KBear Excel Discussion (Misc queries) 2 April 21st 06 01:40 PM
Vlookup referencing one column that contains part numbers in both. crafty_girl Excel Worksheet Functions 2 April 18th 06 07:29 PM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017