Hi all, I have the following piece of code that I found on this site (from Joe [can't remember surname, sorry - thanks again !])
Range("U2").Formula = "=IF(ISNA(VLOOKUP(B2,'Fonetic Report'!B:G,5,FALSE)),"""",VLOOKUP(B2,'Fonetic Report'!B:G,5,FALSE))"
Range("U2", "U" & Cells(Rows.Count...