Originally Posted by Spencer101

Hi Russell,

You'll be glad to hear this is easy enough to sort out.

Taking for example the formula you have in cell I2, change it from =VLOOKUP(H2,AV!$A$1:$B$6,2,FALSE) to =IFERROR(VLOOKUP(H2,AV!$A$1:$B$6,2,FALSE),"") and copy to all relevant cells (Purple ones in columns G to X). That should solve the problem.

Let me know if it doesn't, but it did when I tested it.