Sorry, I'm a bit of a novice with major automatic formulas. Where do i type that formula that you have mentioned above? I want to type into a b column cell. Then for it to pre populate the A and c cell either side according to what i type in the B cell. To match previous mentions of that same b cell mention.