Quote Originally Posted by Fotis1991 View Post
Do you mean in I2 and copy down?

=VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0)
Simples, been looking at this sheet for ages and it was a simple fix.