I've seen someone use a list, but when you selected something from the list,
another value went in the cell.

For example, the list may contain a name John Smith, but when you select
that, only JS is put into the cell. I don't know if this is a "view" or how
it was done. More importantly, I don't remember who did it.