Hi there, I have just found this site and hopefully someone can help with them problem im faced with. I have one sheet within the workbook with the Table shown below where I track the football results from all English and Scottish leagues.
<tbody>
</tbody>By typing the score into HSCORE and ASCORE I am returned the match result for each team in HRES and ARES. In another sheet I have the below table where the last weeks match result is input to form a week by week form guide.
<tbody>
</tbody>Currently I am having to input the match result for each week in manually but what I would ultimately like is to input a formula into each week that would copy the match result from table 1 to table 2 as the scores are input. I have tried a couple of IF statements but struggling to get my head around it. Any help much appreciated.
WEEK | HRES | HSCORE | HOME | AWAY | ASCORE | ARES |
5 | LOSE | NORWICH | ASTON VILLA | 1 | WIN | |
5 | WIN | 4 | MANCHESTER CITY | MANCHESTER UNITED | 1 | LOSE |
<tbody>
</tbody>
Team | 3 | 4 | 5 |
Norwich | LOSE | DRAW | |
Aston Villa | LOSE | WIN | |
Manchester City | WIN | DRAW | |
Manchester United | WIN | WIN |
<tbody>
</tbody>