Thanks again! one more query, how would i add one of those equations to the equation already entered:

=IF(VLOOKUP($C9,'Account Registration'!$B$2:$Y$8596,18,FALSE)=0,"",VLOOKUP($C9,'Account Registration'!$B$2:$Y$8596,18,FALSE))

By using your equation it works but when i delete the original data to replace it with the new bracketed data it fails obviously because the old data has been deleted. So i need to find a way of adding one of your equations to my equation so it all gels,