Place the vlookup within a test for NA:
=if(isna(VLOOKUP(A127,'Wellington
Total''s'!$A$2:$C$1991,2,FALSE)),"",VLOOKUP(A127,' Wellington
Total''s'!$A$2:$C$1991,2,FALSE))
You could replace "" with any other sort of 'default' you like.

"Steved" wrote:

Hello from Steve Dee

Is it possible please to have Nil in place off #N/A

=VLOOKUP(A127,'Wellington Total''s'!$A$2:$C$1991,2,FALSE)

Thankyou.