S
Steved
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.
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.