Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2015
    Posts
    11
    Thanks
    1
    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.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 651 Times in 593 Posts
    nephlim,

    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

    Race1.png

    Race2.png

    On sheet2, set up your validation table for the drop downs

    Race3.png

    Here is an image of how to setup the data validation

    Race4.png

    When the user select a driver in their row, the Driver's value will be placed in the adjacent column.

    HTH,
    Maud
    Attached Files Attached Files

  3. The Following User Says Thank You to Maudibe For This Useful Post:

    nephilim (2015-01-28)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •