i thought had the right formula however the formula i have used in the pic only shows numbers as i didnt count for if a game gets postponed, if a game gets postponed it shows a 'p' instead of a number which messes up the formula.
The formula needs to try and find the team name from column 'c' and show the cell out of column 'j' which it lines up with.
if the teams not in column 'c' the look up needs to find the team in column 'g' and show the cell in column 'k' it lines up in.
(sorry if my explaination of this is bad, i didnt know how to explain it)
<a href="http://tinypic.com?ref=35atdsi" target="_blank"><img src="http://i65.tinypic.com/35atdsi.png" border="0" alt="Image and video hosting by TinyPic"></a>
The formula needs to try and find the team name from column 'c' and show the cell out of column 'j' which it lines up with.
if the teams not in column 'c' the look up needs to find the team in column 'g' and show the cell in column 'k' it lines up in.
(sorry if my explaination of this is bad, i didnt know how to explain it)
<a href="http://tinypic.com?ref=35atdsi" target="_blank"><img src="http://i65.tinypic.com/35atdsi.png" border="0" alt="Image and video hosting by TinyPic"></a>
