Results 1 to 2 of 2
2015-01-28, 06:14 #1
- Join Date
- Jan 2015
- Thanked 0 Times in 0 Posts
Excel Fantasy Formula 1 spreadsheet
I have a spreadsheet, with 5 sheets...
Races - Qualifying - Bonus - Values - Players
I want to be able to insert a list of team into the Players sheet (each player can pick 5 drivers), and I want it to automatically pick up the value of the drivers for that player.
How would I go about doing this?
I want it to be if Value = X then input Y...but can't seem to get it going
Last edited by nephilim; 2015-01-28 at 06:20.
2015-01-28, 06:52 #2
- Join Date
- Aug 2010
- Pa, USA
- Thanked 651 Times in 593 Posts
You can set up the sheet like the example in the images using data validation in the drivers column, and the following formula in the Value column.
Cell B2 =IF(B2="","",INDEX(Sheet2!$A$2:$B$9,MATCH(Sheet1!B 2,Sheet2!$A$2:$A$9,0),2)) and copy down each value column
On sheet2, set up your validation table for the drop downs
Here is an image of how to setup the data validation
When the user select a driver in their row, the Driver's value will be placed in the adjacent column.
The Following User Says Thank You to Maudibe For This Useful Post: