Quote Originally Posted by royUK View Post
Use VLOOKUP
ive tried vlookup which i dont think i could get working. when playing with formulas i managed to get "lookup" sort of working i used some thing like =LOOKUP(A12,AZ1:AZ10000,BA1:BA10000) all data was on the same sheet for this test but when looking at the data i noticed that the postcodes went out of sync after about 500 postcodes