hi,
i'm running a 'world cup' competition at work and need some help.
here is my first prob.
i have one worksheet with all the world cup fixtures on it which will
be used as a master to enter the results as they happen(sheet name
'group results master')
each person taking part will have thier own predictions sheet in which
they will enter thier predictions for each match(sheet name ' pred j
bloggs')
on the prediction sheets i have 2 columns, one for 'match result', and
one for 'correct score'.
what i would like if possible is:
when i enter a result for a game on the 'master', the cell in 'match
result' column
looks at the prediction, and then checks the master to see if correct,
and to return a value of 2, if correct and 0, if incorrect.
i need a simular thing to happen in the 'correct score' column, but
this one will have to check to see if the score on the master is the
same as the score on the prediction sheet, and then return a value of
5, if correct and 0, if incorrect.(all the scores for teams will be
placed in individual cells)

i hope someone can understand what i'm trying to do here, and help me
out.

many thanks,

Mark.


--
boufant
------------------------------------------------------------------------
boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725
View this thread: http://www.excelforum.com/showthread...hreadid=525525