Can some fine person help me with a formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-3026912%22%20slang%3D%22en-US%22%3ECan%20some%20fine%20person%20help%20me%20with%20a%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026912%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20help.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20run%20a%20baseball%20league%20and%20use%20basic%20excel%20stuff%20to%20track%20stats%2C%20rosters%2C%20etc%2C%20including%20some%20vlookups.%20I%E2%80%99m%20trying%20something%20to%20make%20life%20easier.%20Can%20I%20use%20a%20master%20sheet%20with%20data%20and%20link%20that%20data%20to%20go%20into%20multiple%20sheets%20just%20by%3F%20Each%20team%20in%20the%20league%20has%20a%20tab%20for%20its%20players%20and%20salary.%20I%20wanted%20to%20use%20a%20master%20sheet%20with%20all%20the%20players%20and%20the%20players%20salary%20and%20link%20that%20to%20all%20the%2024%20team%20tabs.%20So%20if%20a%20trade%20occurs%20I%20could%20go%20to%20the%20master%20sheet%20with%20all%20the%20players%20just%20switch%20the%20teams%20in%20that%20sheet%20and%20it%20will%20then%20automatically%20swap%20those%20players%20in%20the%20individual%20team%20tabs.%20Is%20this%20possible%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20attaching%20a%20sheet%20with%203%20tabs%2C%20although%20the%20sheet%20I%20normally%20use%20will%20have%20more.%20The%20first%202%20tabs%20are%20for%20%22hitting%22%20and%20%22pitcher%22.%20Those%20are%20the%202%20master%20sheets%20I%20want%20to%20link%20to%20the%20other%202%20tabs%20%22SCR%22%20and%20%22FGB%22.%20In%20those%20to%20latter%20tabs%20%22SCR%22%20and%20%22FGB%22%20you'll%20see%20spots%20for%20%22Name%20Pitchers%22%2C%20which%20will%20be%20linked%20to%20the%20%22pitcher%22%20master%20sheet%20and%20%22Name%20batters%22%2C%20which%20will%20be%20linked%20to%20%22hitting%22%20master%20tab.%20My%20goal%20is%20to%20be%20able%20to%20go%20into%20those%202%20tabs%2C%20enter%20a%20team%20name%20abbreviation%20in%20the%20column%20%22ILSBC%20Team%22%20and%20that%20player%20then%20jumps%20from%20one%20team%20to%20one%20of%20the%20other%20teams.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20the%20%22pitcher%22%20tab%20the%20first%20guy%20listed%20is%20Fernando%20Abad.%20Next%20to%20his%20name%20there's%203%20columns%20(ILSBC%20team%2C%20Salary%2C%20Years).%20I%20want%20to%20put%20%22FGB%22%20in%20the%20%22ILSBC%20Team%22%20column%20and%20he'll%20pop%20up%20in%20the%20team%20tab%20%22FGB%22%20or%20any%20other%20team%20for%20the%20matter.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3026912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I need help.



I run a baseball league and use basic excel stuff to track stats, rosters, etc, including some vlookups. I’m trying something to make life easier. Can I use a master sheet with data and link that data to go into multiple sheets just by? Each team in the league has a tab for its players and salary. I wanted to use a master sheet with all the players and the players salary and link that to all the 24 team tabs. So if a trade occurs I could go to the master sheet with all the players just switch the teams in that sheet and it will then automatically swap those players in the individual team tabs. Is this possible?

I'm attaching a sheet with 3 tabs, although the sheet I normally use will have more. The first 2 tabs are for "hitting" and "pitcher". Those are the 2 master sheets I want to link to the other 2 tabs "SCR" and "FGB". In those to latter tabs "SCR" and "FGB" you'll see spots for "Name Pitchers", which will be linked to the "pitcher" master sheet and "Name batters", which will be linked to "hitting" master tab. My goal is to be able to go into those 2 tabs, enter a team name abbreviation in the column "ILSBC Team" and that player then jumps from one team to one of the other teams.

In the "pitcher" tab the first guy listed is Fernando Abad. Next to his name there's 3 columns (ILSBC team, Salary, Years). I want to put "FGB" in the "ILSBC Team" column and he'll pop up in the team tab "FGB" or any other team for the matter.

1 Reply

Hi @Coly88 

 

if you use Microsoft 365/Office 365, there would be an very easy solution for your problem: The FILTER-function.

I have attached a file where I added a new sheet "FGB_NEW". You will find the formulas in cells A9 and A33.

Apart from the fact, that this function is only available in M365, you need to consider that you have to convert the formatted table back to a range, as these new array functions do not work within formatted table (I have this done in my example sheet)

 

Without M365 I would consider a solution with Power Query.