thanks i found this =VLOOKUP(LEFT(K5,3),'postal list'!$A$2:$B$51,2,FALSE) basically took the first three letters of list i created.... thanks for the help as wel