Cant figure out how to filter/lookup data the way I want.
This is the main spreadsheet I've made for daily fantasy baseball to help with identifying players in a good match up: http://i.imgur.com/HyOvvXG.jpg
Using the sort and filter options to view players at specific positions can be annoying and time consuming when I'm building 20+ lineups.
So on to the issue, the sheet above lists all players at every position. Id like to make a separate sheet for each position ( positions are listed in column B) and have each of those sheets pull the data from the entire row from my main sheet just for players who are eligible at the specific position. So for example I want to make a separate sheet for 1st basemen that brings in just the players with "1B" in column B and their stats from my main sheet. Some players have multiple position eligibility like Cody Bellinger at B272 which is shown as "1B/OF" meaning he can play both 1st base and in the outfield. Im not sure how to approach this or take the multiple positions into account in a formula.
Any help on how to achieve this is much appreciated. Also let me know if I need to explain anything in better detail.
Posted Jun 16, 2017, 7:52 PM UTC · edited