I have a cell which does a vlookup.
But the table to which it refers is always changing and when the specific value is there is shows fine.
But when the value isn't there it shows #N/A - how can I get it to stop this and just display nothing?
Example: =VLOOKUP($P5,GW30!$CI:$CL,2,FALSE) and P5 = Arsenal
So when Arsenal play at home I get a value and it's ok. But when they play away they are listed in a different column and I get a #N/A
I need to stop it showing #N/A please.