Hello from Steved

If I copy from Auckland Kilometres spreadsheet and "paste" or "value" to the
worksheet with the below formula it is fine, I've tried to put --B22
believeing it to be text but also it does not work. What is required please.

{=IF(ISNA(VLOOKUP(B22,'Auckland Kilometres'!$A$5:$E$5007,2,FALSE)),"Out Of
Service",VLOOKUP(B22,'Auckland Kilometres'!$A$5:$E$5007,2,FALSE))}

I Thankyou.