Hi Special-K

Thanks for taking a look into this (and sorry for the delay in replying).

I tried out the formula but it only gives me the results that I have in green (wihin the attached example). In the first formula, I'm not sure how I reference both the old and new site numbers, as I believe that the formula is only looking at column B? ... but then, I have never used the LOOKUP function before so I could well be wrong !