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. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

Any advice would be greatly appreciated.

Thank you!

Oh, thank you - honestly, I wasn't sure WHAT I needed - so I appreciate the guidance.

OK, honestly, I'm super-inexperienced when it comes to formula development and I have never used vlookup before, so any guidance you can provide would be greatly appreciated.