Without full list and/or sample workbook, can't give you exact code.

But I'd imagine, you could first start by creating dictionary/collection/array to store these conditions and use lookup operation in code to change destination value.

Though, I'd recommend storing lookup table elsewhere, to simplify and speed up process.