Pecoflyer, yes - I had worked it out last night. I found a site where they suggest putting the data on another sheet or somewhere out of the way, then call upon that data by using data validation in the cell required, c1

I wanted the final result in C2 so I used a long =if statements to check c1 and return my wanted one letter value. C1 is only 1 wide and melds visually with C2 so I have my wish.

Happy Holiday, Mal