Nil in Place Off #N/A

[Guest]

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.

 

[Guest]

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.

 

[Guest]

Excellent and Thankyou for the expanded explanation.