combine vlookup,isblank,isna in one formula

Might make sense to post a file with your attempted formulae in place so we can see the issue you're experiencing... as is it's not clear where you're looking to place results and what those results should be ie there is no data in your file.

Before we go further... what is the "next step" in this process... I ask because I'm wondering whether or not you really require these tables in the first instance (Home/Away).

I know I'm being cheeky but could you put a file together with the Div 1 sheets but with the headings in English - it will make it a little easier for me to work through (else I have to go through every formula to see where it links to so as to determine what each column represents)

Thanks

Check this attachment

Apologies for delay - cricket & dinner...

Here is a watered down version of your file... I added 2 columns to the Div 1 8-8 sheet to signify result (home win (1), away win (-1), draw (0), not played (9)) and then used those columns along with team name columns to populate the results table - the function used is COUNTIFS and this is new to XL2007 (ie not backwards compatible) - it is however more efficient than SUMPRODUCT which would be used in earlier versions.

I hope it gives you a way forward.