I think he's got some of his parentheses in the wrong places.
What he probably intended was:
=IF(ISERROR(VLOOKUP(A4,'PREMIERSHIP -
NR'!$A$4:$O$203,6,FALSE)),"",VLOOKUP(A4,'PREMIERSH IP -
NR'!$A$4:$O$203,6,FALSE))
--
David Biddulph

Big Trev wrote:
I have put your suggestion in but unfortunately it will not accept
this as it says that too many arguments have been entered for this
function - any more ideas please.

"JBeaucaire" wrote:


Try this:

=IF(ISERROR(VLOOKUP(A4,'PREMIERSHIP -
NR'!$A$4:$O$203,6,FALSE),"",VLOOKUP(A4,'PREMIERSHI P -
NR'!$A$4:$O$203,6,FALSE)))