That makes sense as its having to go into the other sheet and perform the Vlookup twice per formula. Definitely a point worth considering in the future as I currently have 5 columns of this formula over nearly 4000 rows and its likely to get bigger.

Thanks for all your help,

Kind Regards
Alex