Hello owainl,

I presume you want to look at both home and away matches together, your formula is only looking at home games?

Starting with the second part first.....

I think you'd have difficulty doing this with regular formulas because you need a formula that will concatenate a range, I think. You could try downloading morefunc add-in and using MCONCAT function like this

=LEFT(MCONCAT(IF(B2:B13="ars",C2:C13,"")&IF(E2:E13="ars",F2:F13,"")),5)

confirmed with CTRL+SHIFT+ENTER

For Arsenal this will give WLWD because there are only 4 games shown

For the first part I presume the result for Tottenham would be L1 and for Man Utd W4?