So you are going to control the "w" from the master sheet?
It seems to me, the bold is going thru more trouble than neccesary. On the master sheet, enter the winner in column D and the points values in column C. All the individual sheets are set up the same way with the exception of the forumla in column C. If they select the correct winner from the data validation in column D and is matched with column D on the master sheet then they get the points and if not, zero
|