Is it possible to create a list,

For example:
Susan
Jeffrey
Thomas

Use the named list to create a drop-down list on a Worksheet (using Data Validation) and when a selection is made from the drop-down list , see different (associated) data, IN THE SAME CELL.

For example:
Select "Susan" but get "Sue"
Select "Jeffrey" but get "Jeff"
Select "Thomas" but get "Tom"

I thought about using the Conditional Formatter but that doesn't look like there is an option there for me. Perhaps I need some VBA logic to detect the value in a Cell and then change it (behind the scene).

What do you think?