IF Functions, Conditional Formatting

I need to know how i can see week per week whether or not the top team has won each week and slot the findings in Cell M4 downwards week per week.

This would be looking at the team's position on 1st Jan and looking at the points gained on the 2nd (3pts for a win, 1pt draw and no pts for a lose.) The points in the points table are accumlative week per week.

If they do win, i need it to say 'Yes' and if not, 'No.'

Obviously, this is a sample of the data as i have a whole season to compile.

I have attempted to do IF functions with vlookups in them but my excel knowledge is quite limited.

Any help would be appreciated.

Thanks in advance

I'm sure someone has a shorter formula than this, but here's what I put in cell M4 and then copied down:

=IF(INDEX(B11:K11,MATCH(INDEX($B$2:$K$2,MATCH(1,B4:K4,0)),$B$9:$K$9,0))-INDEX(B10:K10,MATCH(INDEX($B$2:$K$2,MATCH(1,B4:K4,0)),$B$9:$K$9,0))=3,"Yes","No")

thats great.

thanks alot.

I am not quite sure why you choose to match the team name, as both tables are the same shape. I think the following suffices

=IF(INDEX(B11:K11,MATCH(1,B4:K4,0))-INDEX(B10:K10,MATCH(1,B4:K4,0))=3,"Yes","No")

Regards

Dav