Yes,

Will a formula suffice (along the lines of 'if column b value = apple then pie, else flan') or do you want a singular value entry (using VBA the value is automatically entered when column B is populated)?

Bear in mind VBA is not very portable as most users have security settings on High as per default.

CC