Change content of one cell based on content of another

Hi! I'm looking for guidance on a formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes.

Any advice would be greatly appreciated.

Thank you!