collapse


Armchair Cyclist

  • Classics Winner
  • *
  • *
  • Country: 00
  • Posts: 3242
  • Liked: 3418
  • Awards: 2020 Tour de France Prediction Champ2020 Worlds Prediction Champ2019 Spring Classics Prediction Champ2018 Tour de France CQ game winner
Re: 2016-18 Emerging Riders CQ Game
« Reply #30 on: February 02, 2016, 20:42 »
Hey AC,

I've just had a look and the formula you're using is trying to find info in the wrong column.

You can either change this

=IF(ISNA(VLOOKUP(A9,Popularity!$E$1:$J$65227,5,FALSE)),
0,VLOOKUP(A9,Popularity!$E$1:$J$65227,5,FALSE))

to

=IF(ISNA(VLOOKUP(A9,Popularity!$E$1:$J$65227,6,FALSE)),
0,VLOOKUP(A9,Popularity!$E$1:$J$65227,6,FALSE))


in every relevant box (which is probably very time consuming). Or you can go to the Popularity table and delete one of the empty columns between the riders' names and their popularity score (H for example). This definitely works as I've just done it but I'm not sure if it might also knock out some of the other formulas.

Hope that helps.

Many thanks: I woke up in the middle of the night realising that the root of the problem was the column I had added just before to the Popularity page so that I could indicate unique picks.  I came down in the morning and deleted the column, and that problem was solved.   I'm still having a different problem though:grrr.
  • ReplyReply

  •  



    Top
    Back to top