I am modifying my spreadsheet for a coming football cup for youths.

Today I have one sheet per Group (Boys89, Boys90, Girls90 etc.) and move
between sheets when entering in the results
The important columns are (A=Match.no, J=Result Home, K=Result Away)
Each match get 0,1,3 points and points are located in column T,U...
Formula in T5 is: =IF(ISBLANK(J5);0;IF(J5-K50;3;IF(J5-K5=0;1;0)))
Goals scored are in column P: (=+J5+J7+J9) and goals against in Q
(=+K5+K7+K9)

When entering the results in cell J5 and K5 the points and goals for and
goals against are updated.

This works fine, but I want to improve entering results. I want to type the
result in one sheet called RegisterResult where all matches are sorted on
match.no from 1 to 162 (no. of matches last year)

The important columns are (A=Match.no, L=Result Home, M=Result Away)
When I register results for match.no. 1 I want to have updated the same
results in the actual sheet.
This works fine using vlookup, i.e.
=IF(ISBLANK(VLOOKUP(A5;RegisterResult!$A$2:$M$162; 12));"";VLOOKUP(A5;RegisterResult!$A$2:$M$162;12))

But this formula creates a problem when no results are registered. The cell
T5 reports #VALUE due to the "" in the above formula (J5) (ISBLANK in cell T5
does not work any more)

I have tried other ways (0 - zero cannot be used (i.e. goalless draw) but
with no luck.

Anybody out there with a way around?

*gublues