Olasa.
Thanks for your input. However, I get an error message referring to the ;"";

Here is more info that might help.

This formula is placed in J5
I have been trying a little of the same as you suggest, but it also fails.
=IF(ISBLANK(VLOOKUP(A5;RegisterResult!A2:L217;10)) ;"
";VLOOKUP(A5;RegisterResult!A2:L217;10))

Here is the related formula (in T5) to the cell above
=IF(ISBLANK(J5);0;IF(J5-K50;3;IF(J5-K5=0;1;0)))
Returns the points either 3 (win), 1 (draw) or 0 (loose)

This formula only works if the cell J5 is empty or contains a number (goals).
The formula I have tried above " " results in a #Value! in cell T5.

So instead of " " as return value if ISBLANK is TRUE it should have been
something like "Leave the cell as it is"/empty.

gublues.


olasa skrev:


It depends on how the rest of the formula looks like.

Op.1
=IF(ISERROR(1/(VLOOKUP(A5;RegisterResult!A2:L217;10));"";VLOOKUP (A5;RegisterResult!A2:L217;10))

Op.2
=IF(ERROR.TYPE(1/(VLOOKUP(A5;RegisterResult!A2:L217;10))=2;"";VLOOK UP(A5;RegisterResult!A2:L217;10))

...might do the job.

Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378600